AnsweredAssumed Answered

Preventing invalid date entries/future dates

Question asked by dwirony on Jul 2, 2018
Latest reply on Jul 2, 2018 by techt

I'm trying to modify a date field to prevent :


1. Invalid date entries (like 6/5/0218)




2. Future dates (compared to today's date)


I've checked off "In range" on the validation tab of my field's options and set the range to 1/1/1900 to 12/31/3999, which will catch 90% of my mis-typed dates (which occur earlier than 1/1/1900). However, I'm having issues restricting the entries of future dates. I've checked off "Validated  by calculation" and I'm using the formula Self   ≥  Get ( CurrentDate ), but when I go back to my layout and enter a future date (for example, 1/1/2050) the date goes through and no error is thrown. What am I missing?