date to text

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Try this

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

Cheers, Graeme
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting date gives bad results in query 2
Converted from LINUX time ok, but having issues with the between date. 4
#error - Blank 3
Looking up across date ranges in Access 2
Numeric Field Overflow when appending date - how to convert it to text 1
Format DATETIME to Date in query on linked table 4
rst.findfirst not working with two conditions 6
Aggregate calculations on calculated query fields? 6

Back
Top