Constraining date in relation with 'today' question

User Support Form Building
,
1

Hi all,

I’m facing difficulties constraining the answer of a date question to 1 or 2 two days before the current date of the survey.
What I want to know is if the data collected are about yesterday or the day before yesterday (and obtain the response in a date format).
Do someone knows what would be the constraint code for that?
I put . < ${today} in order to not have date in the future
but then . < ${today} and . > 2 - ${today} does not works for what I want to do.

Thanks in advance for your responses.
Best.

2

Hi
Using XLS approach can you try the following
image

Regards
Stephane

1 Like
3

Hi Stephane Aloo

I was looking for your email address.

Please email me at: johnkuriaengineer@gmail.com.

Kind regards
JK

4

Hi Stephanealoo

Thank a lot for your answer.
What you propose should work, yes!
In the meantime, I found another way to obtain the result:

image
image.png984×182 4.89 KB

Not sure I ever would have been able to find a way in just one line like you.

Thanks again,
Francois

1 Like
5

Hi
Very nice, quite a clean way to do it.

Stephane

1 Like