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:
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?