Search for dates inside of a text field
Posted on 2011-04-21
In Access 2007, we have a text field in a table where users can type notes as needed. Occasionally, these notes will mention one ore more dates. My task is to run a query that will find date strings within the text field, and return the record in the query results for EACH DATE that is found.
Obviously, I won't be searching for actual date values; rather, I'll need to search for a variety of string formats ('mm/dd/yy'; 'mm-dd-yyyy', etc.). What's the best syntax for doing that?
Also, as mentioned, if the text field for Record #123 contains two date strings, then I'll need Record #123 to appear in my query results twice.
Can anyone show me a good way to accomplish this?