How to enter manually min date, max date

Need help Database
1

Hi,
In Date Picker field I try to put manually values in min & max date but nos success.
Any idea how to do it?

Thanks,
Vangelis

2

Hi there, @alexandermooreint… I’m not sure if this is what you mean, but if you are trying to set a minimum and maximum date for a date/time picker element, one way you can do it is like this.

dates
dates446×812 31.5 KB

The expressions above will set the minimum value to the current date (meaning a user will not be able to select a date in the past), and the maximum value will be set to 90 days from the current date (meaning a user will not be able to select a date that is more than 90 days in the future). You can obviously change those expressions to meet your needs, but hopefully those examples help.

Best…
Mike

3

If, by ‘manually’, you mean that you want to set the min/max values to some arbitrary date, then use the ‘Arbitrary Date’ option in the expression.

4

Thanks a lot actually I need minus 18 years from now. I found +years only. In order to subtract the manual value is -18?

5

Yes, use the +(years) operator, and enter a negative number.

6

Thanks, solved

1 Like