date to text

M

Mal

I have a linked table with date 12/31/03 and need to export this field to ASCII as 12310
The linked table varies so I need a query to change the format only. Can this be done
 
G

Graeme Richardson

Try this

format(MyDate,"mm") & format(MyDate,"dd") & format(MyDate,"yy")

Cheers, Graeme
 
Top