Data Type Conversion in Query

[EHittner]

How do I convert a date string that's in text format to date format? I.e., "10/04/2004" is treated as text and I want to use it in a date comparison function. I want to do this automatically using a query so I don't have to manually change the format in the table each time.

[pbaldy]

Try the CDate() function.

[EHittner]

CDate was just what I needed. Thanks much!

[pbaldy]

No problem, glad it worked for you.