AnsweredAssumed Answered

Importing Excel Timestamps into Filemaker

Question asked by MacDevGuy on Jul 10, 2018
Latest reply on Jul 12, 2018 by bigtom

I did a search and couldn't find anything about this though I do recall seeing something about this either here or in fm documentation. Or maybe it was someone elses blog?

 

I have an excel spreadsheet I want to import into an FMP db. How does FM treat dates it's importing from Excel? Does it convert the date into a usable form that will continue to work or do I need to do some type of conversion on the timestamp?
There are two date fields, the first being the date and time of creation:  

4/1/15 12:45

The second being the date and time of last modification:

01-APR-15 04.34.24 PM


Is Filemaker smart enough to convert these to a usable timestamp?

Outcomes