12 Replies Latest reply: Aug 25, 2014 1:23 AM by AVIRAL NAG RSS

    Date Format

    AVIRAL NAG

      Hi All

       

      I have date field in this Format:    07-08 8-2013 12:44:11

      I need date field in this Format:    07-08-2013 12:44:11

       

      Only Month is in different Format.

       

      I am getting desired result by using this:

      SubField(SystemClosedDateTime,'-',1)&'-'&Left(SubField(SystemClosedDateTime,'-',2),2)&'-'&Left(SubField(SystemClosedDateTime,'-',3),4)

       

       

      Is there any other way which will only change the month Format (08 8) and rest Date and Year work as it is.

       

       

      Regards

      Aviral Nag