2 Replies Latest reply on Dec 13, 2012 6:55 AM by brian.curran

    Month (DateField) but with a 2-digit number including a leading zero?

    brian.curran

      Title

      Month (DateField) but with a 2-digit number including a leading zero?

      Post

           As per the title really, is there a way to extract the Month from a date and have it as a 2-digit number?

           _cIncidentNumber = 
           Year ( DateField ) & Month ( DateField ) & Day ( DateField ) & "/" & TimeField

           The above converts 07/06/2012 and 14:15 to:
           201267/14:14 but I need it to look like
           20120607/14:14

           is there another way to flip the date into reverse and keep leading zeros?

           Thanks
           Brian.