7 Replies Latest reply on Jan 21, 2016 7:08 AM by jcondle

    Question about converting date at times calculated as serial number to actual date/time

    jcondle

      I have a csv file where all the dates and times are calculated as serial numbers.

      Per given data dictionary

      In the dataset, the time integer is the number of seconds from midnight.  Thus the range is from 1 to 86400 (24*60*60) where for example 7:01:05AM is 25265 (7*60*60 + 1*60 + 5). The dates are in integers with a base of January 1, 1960.  For example, January 1, 2012 is 18993 and January 1, 2014 is 19724.

       

      Dates in excel are based of 1900,  I have been searching google looking for a way to convert this serial numbers back to their actual dates and times so I can do the conversion on import into filemaker.  I looked at the date functions in filemaker I do not think there are any built in functions for this,

       

      Looking for some help

      Thanx

       

       

      Joe