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.
send me the database?
i tryed using ">=Now()-1" it works but now when i run a query for todays date it cannot find anything!!! AAAHHH
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.
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...
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 :-)
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.