How to validate a date?

Question

Hi!

I want to ensure that the date entered in a "date" is between 01 January 2010 and 31 December 2010.

I added a validation rule that reads: $this >='01/01/2010' and $this <= '12/31/2010' but I always get an error message whether I am in 2010 or not.

Any idea of what I need to change?

Many thanks,

Florence

Answer 1 · 2017-05-05T05:08:54

0

Accepted answer

Hi Florence,
The format for the date is this: 'yyyyMMdd'
E.g. '20170505'.

Thanks,
Open Foris Team

Answer 2 · 2017-05-05T15:39:54

0

Accepted answer

Many thanks Open Foris team, for the answer and your super responsiveness!!

Florence

2 Answers