Querying Todays Date from a text field

  • Thread starter Thread starter Ann Withington
  • Start date Start date
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.
 
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.
 
Back
Top