Date/Time Timestamp to separate date and time fields
Is there a way to take a timestamp that includes the Date and Time, e.g. 12/11/2012 14:24:06, and import it into another database that has separate "date" and "time" fields? I thought I had this set up and working before but now only the date is importing but not time. Did something change with FM11? It seems like time stopped importing around the time that we upgraded.
There was no change in behavior with Filemaker 11 that would affect this as far as I know.
GetAsTime and GetAsDate are functions you can use in calculation fields to extract either the date or the time from a timestamp field. You can then export from these calculation fields to export the date and time into separate fields in the exported data.