AnsweredAssumed Answered

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

Question asked by brian.curran on Dec 13, 2012
Latest reply on Dec 13, 2012 by 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.

Outcomes