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

    Reformatting date time field

    msingh _

      Hi,

       

      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:

       

      Ctod(,"y/m/d","D")

       

      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??

       

      Thanks!