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.
Right ( "0" & Month ( DateField ) ; 2 )