date to text

[Guest]

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

 

[Graeme Richardson]

Try this

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

Cheers, Graeme

 

[Graham R Seach]

Mal,

Format(myDate, "mmddyy")

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html