View Single Post
  #1 (permalink)  
Old June 15th, 2005, 05:21 PM
bekim bekim is offline
Friend of Wrox
Join Date: Jun 2004
Location: Alhambra, ca, USA.
Posts: 245
Thanks: 0
Thanked 0 Times in 0 Posts
Default Easy Ques -- Datetime validation for Access

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.

Reply With Quote