Hi all,
New to the forum and SQL and MS Access.
I need some help with a date validation query.
I have a dataset where all the columns need validating, one of these columns is a date column. In Access this date column is a text column as the dates are manually entered and can be incorrect. I need to find these incorrect dates in order to send the dataset back to be corrected. I use the ISDATE function and can identify which dates are not in the correct format. However I need to do other date validation checks i.e. whether a date is in the future. Is it possible to build a query that will look at each date in the column and if it looks like a date then treat it as a date, if it doesn't look like a date then ignore?
Hope that makes sense.