I'm working in Access DB on large sets of data. There is a string field in my query called "Doc_Date" which I have imported from another source. I would like to select all records WHERE the "Doc_Date" IS NOT LIKE a date format (i.e. 'm/d/yyyy' ).
Below is an example of the select results and an example of the select results with the WHERE clause to return the records that is not in the 'm/d/yyyy' date format. Thanks for the help!