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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting date gives bad results in query 2
Date format in query export. 4
Name, Date and Address Formats 2
Format DATETIME to Date in query on linked table 4
date format lost in UNION query 4
Enter date as DDMMYYYY 3
Problem with Cross qry 1
Date query 2

Back
Top