Export Date to outside system

[Guest]

I need to export a date as a mm/dd/yyyy from Access so that I can import this
txt file as a date. Whenever, I format my query, table, or field it comes out
as Date/Time field i.e. mm/dd/yyyy 00:00:00:0. Even when I change my criteria
on the export the date does not go through as I need it to. Any suggestions?
Thanks.

 

[Guest]

format(Date,"mm/dd/yyyy")

 

[Guest]

Hi,

I also have this problem, however, when I try and use the formula below it
changes to d"ate,"mm/dd/yyyy. Perhaps I am doing something wrong?

 

[Guest]

Interesting.
Format(Date,"mm/dd/yyyy") on today's date should return 10/05/2005
Post back your code so we can see if there is a problem

 

[Guest]

I forgot to mention you could also try Cstr(Date)

 

[Rick Brandt]

Interesting.
Format(Date,"mm/dd/yyyy") on today's date should return 10/05/2005
Post back your code so we can see if there is a problem

Format(Date,"mm/dd/yyyy")

....should work in VBA code. In a query or ControlSource expression you need
to add the parenthesis.

Format(Date(),"mm/dd/yyyy")