what is maximum/minimum value for date field

aikotoba
Tera Guru

So far we have confirmed that the following values can be entered and saved

minimum:0001-01-01

maximum:9999-12-31

But the picker is not working properly.
Could you please provide me with the correct information?

1 ACCEPTED SOLUTION

GlideDateTime and GlideDate both support earlier dates so if the dates were manually entered, it would be saved. However, if the user opens the DatePicker, it will change the date to the current date and the date must be manually entered again.

Example:

Field "Date" is of type Date. I'm able to save dates "0001-01-01" and "9999-12-31" into the table.

find_real_file.png

However, if I open DatePicker on the field with value "0001-01-01", it will set it to today instead of "0001-01-01".

find_real_file.png

If I close the date picker, the date will be set to today so it's necessary to manually enter the date again.

find_real_file.png

To avoid showing datepicker, set the field type to "Single line text" and add date validation.

View solution in original post

5 REPLIES 5