CDate in my append query

[Steven.Allman]

Importing individual records from a massive database. As I import, i would like to change the format on the fly of the dates, which are stored as text in DB1, as to store them in date format in DB2, my new DB.
I have seen lots of info on the CDate function but cant figure out where to place it, and how to use it. My query works great, but I need to be able to use this 'date'

YYYYMMDD is the format in DB1 'TEXT" field



I could care less what format I get out of it!

[pbaldy]

CDate() may not work on that format, but if it does it would look like:

CDate([YourFieldName])

If it doesn't work (my guess), you probably need to use DateSerial() with the Mid() function to pull out each component of the date.

[kennejd]

I think you'll need to use your mid and right and left functions to get this:

mid(yourdate,5,2) & "/" & right(yourdate,2) & "/" & left(yourdate,4)

[pbaldy]

You can use Mid() for them all:

?dateserial(mid("20110411",1,4),mid("20110411",5,2 ),mid("20110411",7,2))
04/11/2011