Querying Todays Date from a text field

A

Ann Withington

Hi:

My co-worker is importing text data into a table that we
have. One of the fields is the occurence date - as a text
field. So how can I query the data only from today if the
field from the table is text. Obviously the TODAY()
function does not work.
 
K

Ken Snell [MVP]

Assuming that the dates are stored in the text field in a format that ACCESS
can unambiguously recognize (always mm/dd/yyyy, for example), you can use
the DateValue function to convert the string into a date value.
 
Top