How to validate a date field for dates that are in the future or Past?


#1

Hello,

I have a requirement to prevent future dates from being entered in a date field. Can anyone tell me if this can be done and how?

Similarly I want to restrict date selection to say just two months in the past. Can this be done?


#2

I can think of a not so elegant workaround using a secondary table with a field for each date for the next 5+ years. Then using a linked record field in the primary table to filter view of the secondary table where the view filters from Today to Today-60 days. It would only show 60 records, so it wouldn’t terrible to scroll through.

The main issue with this idea is that it would require you to create the date records ahead of time, but should be easy enough to create them for the foreseeable future.

I’m not going to elaborate further in case someone else can think of something more elegant to try.


#3

Thank you for the idea