date conversion

[Dave Waling]

I am linking to an AS/400 database and the dates are
displayed in Access as text fields in the yyymmdd
format. Since they are in text format I can't do date
quries.

How can I convert the text into a date field Access can
use for queries?

Thanks four your help and suggestons.
Dave

 

[Ken Snell [MVP]]

see replies in other newsgroup (queries?) where you posted this question. at
least, i think it was you...question was essentially the same

 

[Douglas J. Steele]

Assuming the date is stored in a field named TextDate, the following will
convert it to a date:

DateSerial(Left([TextDate], 4), Mid([TextDate], 5, 2), Right([TextDate], 2))