0

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.

4
Contributors
5
Replies
6
Views
12 Years
Discussion Span
Last Post by relawson
0

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

1

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.

Votes + Comments
Good Job
0


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

Cheers mate, it works a treat. Ive been struggling with that for ages, thats a great help...

0

Cheers mate, it works a treat. Ive been struggling with that for ages, thats a great help...

Another great "feature" brought to you by Microsoft :-)

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.