I have a table with 15k records and date field defined as a text with dates stored as mm/d/yyyy
Most dates are OK, some dates are not are not valid.
DATE OF MARRIAGE
12/31/1990
12/31/1990
12/71/1913
14/04/1975
14/12/1969
17/17/1970
17/17/1970
I want to build a query that will list all the records with the date field and a additional column with OK (for good dates) or NG (for bad dates)
I have this so far however it dosen’t return any records:
SELECT [MARRIAGE LICENSES].ID, IsDate([DATE OF MARRIAGE]) AS Expr1 FROM [MARRIAGE LICENSES] WHERE (((IsDate([DATE OF MARRIAGE]))=True));
What am I doing wrong?
Thanks, John