9 Replies Latest reply on Feb 7, 2012 4:18 AM by acwei

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


      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.