InfoPath 2010

Re: Date validation less than or equal to today() not working

thiyagu1990 — Tue, 04 Sep 2018 11:05:23 GMT

Thanks a lot GSWAN.. now() is working perfectly... :-)

Re: Date validation less than or equal to today() not working

Deej2323 — Thu, 15 Sep 2011 16:08:55 GMT

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!

Re: Date validation less than or equal to today() not working

GSWAN — Thu, 15 Sep 2011 15:48:01 GMT

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

Re: Date validation less than or equal to today() not working

Jimmy — Thu, 15 Sep 2011 15:43:27 GMT

Try translate(date, '-:T', '') <= translate(today(), '-:T', '')

Date validation less than or equal to today() not working

Deej2323 — Thu, 15 Sep 2011 15:36:32 GMT

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!