Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Hi
Try this
Let vCurrDay= date(today()-1)
and
Let vPrevDay = date(today()-2)
Hope this helps.
Andrei
Hi
Try this
Let vCurrDay= date(today()-1)
and
Let vPrevDay = date(today()-2)
Hope this helps.
Andrei
ok so thats sets up the variables great, but the my set analysis doesn't
Sum({1<call_date = {$(vCurrDay)}>} calls_offered)
Hi,
Please check variable value and your call_date in text object.
And ensure that call_date has a date format.
HTH
Andrei