Date format

  • Thread starter Thread starter Alex Martinez
  • Start date Start date
A

Alex Martinez

Hello,
I get data from our main frame via pass thru query. My problem is that the
date format is 18-NOV-05 and I need to have it change to 11/18/2005 in my
query. How can I get it to be 11/18/2005. Any tips will be appreicated.
Thank you in advance
 
Hello,
I get data from our main frame via pass thru query. My problem is that the
date format is 18-NOV-05 and I need to have it change to 11/18/2005 in my
query. How can I get it to be 11/18/2005. Any tips will be appreicated.
Thank you in advance
Click to expand...

Try

CDate([yourdate])

and set the Format property of the field to mm/dd/yyyy.

John W. Vinson[MVP]
 
Back
Top