Max date in picker

Ask us anything
1

Hi,

I am using a date picker and am using the max date formula - formatDate(addDays(date(),1,“YYYY-MM-DD”).

This shows up to today’s date but does not allow me to select it. If I use date(),2, you can select today’s date but tomorrow’s date is not greyed which gives the impression that it can be selected.

Screen Capture video here

How do I get the picker to show today’s date as the max that can be selected and allow me to select it.

Thanks
Steve

2

try something like this

image
image749×829 77.4 KB

3

This has the same behaviour, todays date is shown as the current value but in the date picker it is not selectable.

image
image988×407 20.5 KB

4

sorry maybe I don’t understand, in your image today isn’t the current value of the date picker its just highlighted as a reference. See in the attached image the 22nd is the current value and today has a boarder. If you want to set the current value on load you can set the initial value.

image
image246×314 9.5 KB

5

My dates are yyyy-mm-dd so the date shown in the current value “2025-08-07” is correct. And it is highlighted with the border as today’s date on the picker but I cannot select it.

I believe that the behaviour is more date < today’s date rather than date <= today’s date.

6

Got AI to write me javascript which works -

// Get current date
const today = new Date()
// Set time to end of day (23:59:59.999) to include all of today
today.setHours(23, 59, 59, 999)
// Return ISO string format
return today.toISOString()