Date Validation

I have a form to fill. In this form, I want validation in date. means the entry date will last 5 days. this will help to prevent entering an old date.

For example

if todayโ€™s date is 30/05/21

Then I want to enter the value between โ€œ25/05/2021โ€ to โ€œ30/05/21โ€, means less then 5 days date they can possible to enter

0 3 515
3 REPLIES 3

Steve
Platinum 4
Platinum 4

This will work?

OR(([Date] โ€บToday()-5),( [Date]โ€นToday()+5))

Try it and find out.

Top Labels in this Space