Access date formats

[AFKAFB]

Hi
I'm exporting an access file to txt.
I'm having problems with the date. Its been set to short date 'dd/mm/yyyy' but when viewed in the text file its shows as 'dd/mm/yyyy hh:mm:ss'

how do i suppress the hours, mins and seconds.
regards
chris

 

[PHV]

Why not using the Format function in your export query ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ptpaton]

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

-Patrick

Nine times out of ten, the simplest solution is the best one.

 

[AFKAFB]

hi
am a tad lost here
the field is in a table which i'm exporting
where would i put the expression
Format(DateField,"mm/dd/yyyy")

 

[ptpaton]

If possible, always save data in a table unformatted. It's best to format only where the end user sees the data. In a blank column in your query, type this into the field box.

Date: Format([DateField],"mm/dd/yy")

This will format your datefield to short date.



-Patrick

Nine times out of ten, the simplest solution is the best one.