DateTime Minimum Date and Maximum Date

[Fabian_Weller]

In a DateTime column type we can set the Minimum Date and Maximum Date.

But it seems not to work. I still can choose and save a date beyond.

---

Here is also a nice feature request about using an expression for that.

Minimum date by formula Feature Requests

Hi, I’ve recently noticed that there are “Minimum date” and “Maximum date” options when using a DateTime type column. I know that it is very likely that you are already working on this but just incase: It would be good to have those same options on the Date type column and on the Time type column (As Minimum time). Also it would be great to have those options both as a fixed date and as a DateTime-Expression, since for now it is only possible to use a fixed date for the DateTime type columns…

[Steve]

Perhaps try a valid DateTime format?

[Fabian_Weller]

This is done by AppSheet. When you enter “05/01/2021” and save it, AppSheet will change it to “2021-05-01T00:00:00”

[Steve]

Oh, wow! Yeah, that’s a bug. Please contact support@appsheet.com for help with this. I’ve also escalated.

[Fabian_Weller · Accepted solution]

This is working now.