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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Numeric Field Overflow when appending date - how to convert it to text 1
Count text values in a Access Field 0
Querying between two dates doesn't work if Start and End are ident 10
#error - Blank 3
Select Date For Query 2
Create Date Field from Text 2
Date query 2
Split data in field on character return 0

Back
Top