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?