Hello
I am a SQL Server user and a first time Access user. The Start_date column in Access contains invalid Datetime. Whoever designed the Access allowed users to enter the start date so I have some rows that have an invalid start date like 9/9/199.

I have 150,000 records. How can I tell which rows are invalid. I also noticed that T-SQL that use in SQL View don't always work.
Help me please.

If the Date column is Text, then you can use an input mask and Access will run its own validation rules.

You can also program validation rules on a Date column.

I am not sure how I would approach validating existing records. I could write a brute force routine that would do it, but I am sure some of the posters here will have more elegant solutions.


mmcdonal

Date Column is datetime datatype. Can someone give me a more specific answer to this problem?

Should I make the Date Column into text first? How do I do that in Access?