Set Date limit

[Albino_Pereira]

Hi,

I’ve a table with a Date column. I would like to set a limit to the date that user can input. for instance, the date can’t be after TODAY() + 8 month. can’t find a way to do it.

Thanks for your help,
Al

[LeventK]

First read this:

Guide on How To Create a Community Post Tips & Tricks 💡

Dear valuable members and users, For a long time I’m seeing a lot of multiple and concurrent posts, posts like novels seeming to aim the Pulitzer Price, exactly the same questions by the same user but paraphrased/re-phrased etc. Being a dedicated community member and an AppSheet developer who is reading around 2.5K posts per day, I urged myself to tip on some good advice and best practice BEFORE posting something in the community: #1 - APPSHEET DOCUMENTATION AppSheet has a very good help do…

And then take a look at these docs:

help.appsheet.com

Valid_If Column Constraint

How to check if a given form input is valid based on its type.

help.appsheet.com

EOMONTH()

Date of last day of a month from Date or DateTime

help.appsheet.com

Date and Time Expressions

Incorporate dates and times into the behavior of your app.

[Albino_Pereira]

Thanks for your reply.
I’m aware of the Valid_If constraint and I’m already showing a warning message in case of invalid date.
I realize I should have detailed more my request. What I was looking for was a way for even not showing to the user the invalid dates … so stopping the calendar ‘next’ command when it reaches the limit.

Thanks,
Al

[LeventK]

I belive I couldn’t be able to grasp what you are querying for.

[Albino_Pereira]

Hide the ‘next month’ arrow if it reaches the max date limit…

[LeventK · Accepted solution]

You can’t have a control on that, sorry.