Hi all,
I'm trying to apply a date validation of <= today() and it doesn't seem to be working because it's letting me enter today's date without giving me an error. I thought I could out-smart the validation rule by changing the validation to < today()+1 but then it won't let me put in today OR tomorrow.
What am I missing?
Thanks!
Try translate(date, '-:T', '') <= translate(today(), '-:T', '')
Might also be worth trying to use now() instead of today, particularly if you are using both a date and time in the form. I had a similar issue recently where this resolved it.
Grant
Thanks for the input guys. Looks like now() is going to work! Jimmy, I didn't try your formula because now() was the easiest choice. I will keep this thread bookmarked just in case now() doesn't work at some point.
Thanks again!
DJ