AnsweredAssumed Answered

How do I  get month, date, year, time, etc. from Timestamp field

Question asked by acwei on Feb 4, 2012
Latest reply on Feb 7, 2012 by acwei

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.

Outcomes