Computer Science

Microsoft Access date validation

Please support our Computer Science advertiser: Learn about neural networks and artificial intelligence.

•

Join Date: Feb 2005

Posts: 92

Reputation: NuGG is an unknown quantity at this point

Solved Threads: 1

NuGG

Offline

Junior Poster in Training

Microsoft Access date validation

Mar 15th, 2005

Im using the validation rule ">=(Now())" to ensure the date entered in the field is today onwards only. However, this rule does not allow todays date to be entered. How can i get it to accept todays date but not previous dates?

This is part of my a-level coursework, so if you can help me it would be great...

cheers.

•

Join Date: Dec 2004

Posts: 2,413

Reputation: Comatose is a jewel in the rough

Solved Threads: 211

Comatose

Offline

Taboo Programmer

Re: Microsoft Access date validation

Mar 15th, 2005

send me the database?

•

Join Date: Feb 2005

Posts: 92

Reputation: NuGG is an unknown quantity at this point

Solved Threads: 1

NuGG

Offline

Junior Poster in Training

Re: Microsoft Access date validation

Mar 15th, 2005

i tryed using ">=Now()-1" it works but now when i run a query for todays date it cannot find anything!!! AAAHHH

•

Join Date: Feb 2005

Posts: 199

Reputation: Tight_Coder_Ex is an unknown quantity at this point

Solved Threads: 14

Tight_Coder_Ex Tight_Coder_Ex is offline

Offline

Junior Poster

Re: Microsoft Access date validation

Mar 16th, 2005

In Access, VB & Excel today is 38,427 days since Jan 1, 1970. The time becomes the fracation protion, so at the time I'm writing this response it's 38,427.31. Now at 3:30 pm today 38,427.65 you lanuch you application and try to enter data that was for ealier today it won't work because >=now ().

chang your formula to >= int(now()) and it will work fine.