p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access (http://p2p.wrox.com/forumdisplay.php?f=18)
-   -   Easy Ques -- Datetime validation for Access (http://p2p.wrox.com/showthread.php?t=30493)

bekim June 15th, 2005 05:21 PM

Easy Ques -- Datetime validation for Access
 
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.[?]


mmcdonal June 16th, 2005 09:13 AM

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

bekim June 16th, 2005 01:52 PM

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?



All times are GMT -4. The time now is 10:09 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.