Exporting Date to Text

[Esther7101]

Can someone please tell me how I can export dates without times in Access 97? I have tried the short format, but I still get the time. I am sure that I am missing something simple, but am really stuck.

 

[TonyJollans]

Hi Esther7101,

Export them to where?

If you are exporting them as text then just formatting should be sufficient but if you are exporting them as Date values (to Excel perhaps) then time goes with them and the best you can do is make the time portion zero (equivalent to midnight at the start of the date).

Enjoy,
Tony

 

[PeteJohnston]

You should be able to use

DateValue(fieldname)


[COLOR=red][i]PeteJ[/i][/color]
(Contract Code-monkey)

[u]It's amazing how many ways there are to skin a cat[/u]
(apologies to the veggies)

 

[leighflo1]

What i do is write a Make Table Query based on the table you want to export. Create a field instead of your date field as follows

NewDate: Format([YourDate],"dd/mm/yyyy&quot

Then export the newly formed table to anything you like will get rid of the time.

Hope helps