HAVE QUESTIONS? CALL US TOLL FREE 866.425.0800 OR DIRECT AT 214.239.1985

KNOWLEDGE BASE

   Home      FAQ      Help   
  
Custom Calendar Dates within a .CSV file
Question
ID
49
Category
Office Timesheets
  Import/Export
Date Created
8/21/2007 12:58:36 PM
Date Updated
8/21/2007 1:29:04 PM
Why does the Custom Calendar Date(s) show as a number instead of the usual standard date format in my .CSV file?
Answer
Custom fields of a date type such as the calendar date are stored in the database as an OLE Automation date format. An OLE Automation date is implemented by Microsoft as a floating-point number whose value is the number of days from midnight, 30 December 1899. For example, midnight, 31 December 1899 is represented by 1.0; 6 A.M., 1 January 1900 is represented by 2.25; midnight, 29 December 1899 is represented by -1.0; and 6 A.M., 29 December 1899 is represented by -1.25.

Therefore, a date of 08/22/2007 in Office Timesheets may be displayed as "39316" when exported in a .CSV file. Once the .CSV file is imported back into Office Timesheets it will display as 08/22/2007.



Related articles
Was this information helpful?
 
Back to Search Results
FREE TRIAL

HAVE QUESTIONS? CALL US TOLL FREE 866.425.0800 OR DIRECT AT 214.239.1985