Access date formats

A

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
 
R

RuralGuy

It sounds like you will need to use the Format() function.

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
Click to expand...

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
J

John Vinson

hi
can you explain this a bit further
regards
Click to expand...

Create a Query based on your table. In a vacant Field cell type

ExpDate: Format([datefield], "dd/mm/yyyy")

Select whichever other fields you want to export.

Export from this query rather than directly from your table.

John W. Vinson[MVP]
 
Top