3 Replies Latest reply: May 15, 2014 9:51 AM by Grant Perkins RSS

    Reformatting date time field

    msingh _



      I am fairly new to Monarch and am having a problem figuring date time reformatting.


      I have date time fields of 2 types one that come only with the date for eg. 20040902(y/m/d). I am able to reformat this to 09/02/2004 (m/d/y) using:




      Now I have the other type that includes a time part as well for eg. 20040902142313 (ymdhms). Now I cant figure how to format this to:

      09/02/2004 02:23:13 PM . I am using Monarch 7.


      I have tried various combinations of string manipulations but they wont work.


      Any clues anyone??