Export Date as DDMMYYYY

  • Thread starter Thread starter Mo
  • Start date Start date
M

Mo

I need to export a date field in the above format. I can extract the various
parts of the field ok. How do I format the output so that dates like 1st
January results in '01012004' rather than '112004'.

Thanks for any help.
 
Mo said:
I need to export a date field in the above format. I can extract the various
parts of the field ok. How do I format the output so that dates like 1st
January results in '01012004' rather than '112004'.

Thanks for any help.
Click to expand...

FormattedDate: Format([DateField],"mmddyyyy")
 
Back
Top