AnsweredAssumed Answered

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

Question asked by jcondle on Jan 17, 2016
Latest reply on Jan 21, 2016 by 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

Outcomes