Author Topic: Import of Dates  (Read 1957 times)

barrywells@tds.net

  • Newbie
  • *
  • Posts: 5
    • View Profile
Import of Dates
« on: July 08, 2012, 01:15:18 PM »
Having issue with importing dates.  If I import the date as 1/1/2004, it brings it in as 1/1/2001? I checked by format etc and tried different formats.  On other formats,  the date does not import, though it said it did.. Nothing is on the screen.  Puzzling..

Radishworks

  • Hero Member
  • *****
  • Posts: 1318
    • View Profile
Re: Import of Dates
« Reply #1 on: July 08, 2012, 08:26:31 PM »
Importing date formats should be in YYYY-MM-DD format, like 2013-06-30.  See if that helps.

barrywells@tds.net

  • Newbie
  • *
  • Posts: 5
    • View Profile
Re: Import of Dates
« Reply #2 on: July 08, 2012, 09:56:36 PM »
Yep that did it.. took a bit.. Cause when it exports it comes out as mm/dd/yyyy.

Fixed now.