Export Date to outside system

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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?
 
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
 
Klatuu said:
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")
 
Back
Top