I imported a date and time field from Microsoft Access and put data in FM timestamp field. Data in timestamp field is in the following format: 4/22/2006 6:32:50 PM.
I'm trying to create year, month, day of week, and time fields from the data in the timestamp field but the date functions [i.e. month(date), year(date), etc.] do not work. I am hoping that there is a simple solution... in MS Access, their functions work for the time/date field format above. Any help will be much appreciated.