convert string to date in query

[brad78]

Hi all,
Probably an easy question but in a query I need to convert a text field (expires) into a date in order to do a comparison to todays date. My text field in my table is already formatted as mm/dd/yyyy but when I try to compair to todays date, I don't get the proper result. Can anyone give me a quick hand here? My query is below.

SELECT page_file_name, expires, page_status FROM html_files WHERE (expires > today) AND (page_status = "live");

Thanks in advance

 

[Rabbie]

Try using the CDATE function

 

[brad78]

I'll give it a shot, thanks!

 

[raskew]

Or the DateValue() function.

Bob

 

[brad78]

gees, I thought it was a stupid question and boy was I right. I recreated the query in the wizard and used <Date() and it worked perfectly. Thanks for all the help guys, much appreciated!