Format date to export

Pdeters
Pdeters used Ask the Experts™
on
I am exporting a field to a .csv file
One of the fields is a date/time
I need it to export like this
ddmmyyyy
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
You can use the format function to format dates. Something like this:
FORMAT(Filed, "ddMMyyyy")
http://www.techonthenet.com/access/functions/date/format.php
P.
Most Valuable Expert 2014
Commented:
Make a query and on the field do this:

Format(MyDateFld,"ddmmyyyy")

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial