Dates.

[#1]

Hi All,

I have the following script that sets up my variables:

Let vCurrYear=year(today());

Let vCurrMonth=month(today());

Let vCurrDay= (I want this variable to be set to the previous day in date format)

Let vPrevYear=Year(AddYears(today(), -1));

Let vPrevMonth=Month(AddMonths(today(),-1));

Let vPrevDay=(I want this variable to be set to the vCurrentDay-1 day in date format)

Please help,

[crusader_ · Accepted solution]

Hi

Try this

Let vCurrDay= date(today()-1)

and

Let vPrevDay = date(today()-2)

Hope this helps.

Andrei

[#3]

ok so thats sets up the variables great, but the my set analysis doesn't

Sum({1<call_date = {$(vCurrDay)}>} calls_offered)

[crusader_]

Hi,

Please check variable value and your call_date in text object.

And ensure that call_date has a date format.

HTH

Andrei