Hi,

I have a survey where I need to display different text + admin email based on the below:


IF {CommissionDate} >= today's date - 60 days, TRUE, FALSE

I found that to get today's date i can use {date('d/m/Y')} but if I add -60 at the end it displays as "NAN".

I also tried: {(date('d')-60)+'/'+(date('m'))+'/'+(date('Y'))} which is displayed as -39/02/2018.

Any ideas? (I suck at PHP and java, so please don't suggest any of those)

What format is ComissionDate? Is it a question?

Commission date is a question in 'dd/mm/yyyy' format

Hi,

Today: {date("Y-m-d")}
60 days ago: {date("Y-m-d",strtotime("-60 days"))}



Best regards
Joffm

Thank you! Works great

One more thing. Do you also know how to use this validation to show a question?

Basically I need to show a question which will say: Sorry, not covered under warranty if the commission date is >= today-60

Thanks

Set Relevance of that question to

ComDate>date("Y-m-d",strtotime("-60 days"))

But is this correct?

Sorry, not covered under warranty if the commission date is >= today-60

If it is within the last 60 days it is NOT covered?

Joffm

Just use your same equation in the "relevance equation" of the question. It will be validated as a bool, so something like (ComissionDate >= date("Y-m-d",strtotime("-60 days"))) or however your equation ended up like !

My bad the > is the other way around

I did try to set the relevance but it is not working:

if(INSERTANS:669123X299X2380<=date('d/m/Y', strtotime("-60 days")),1,0)

Try removing the if-statement, (INSERTANS:669123X299X2380<=date('d/m/Y', strtotime("-60 days")))

Yes I realized, it is still showing the question no matter what date I enter.

Or convert it to epoch time. So, something like this for the relevance equation:

...sample survey attached:

Thanks, dont know how to view samples. I will try to convert to epoch

Just import the survey.