Query for Dates

[k209310]

Hello

Is it possible to write a query that will search for data that is not a date?

I am trying to change a fields data type to 'Date' however there a four fields that are not in the correct format (#dd/mm/yyyy#). I am tiold this when i try to change the tyope and save the table. I was wondering if there was a way to search for these rogue records. There are too many records to search by hand.

I could just delete them if the worst comes to the worst but obviously id rather not.


Thanks

Chris

 

[Mile-O]

Make a calculated field in your query.

TestField: IsDate([DateField])

and make its criteria: False


This should return the culprits.

 

[k209310]

Thats great. Thanks

Chris