Date Validation

AppSheet AppSheet Q&A
,
1

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

2

This will work?

OR(([Date] ›Today()-5),( [Date]‹Today()+5))

3

Try it and find out.

1 Like