Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In my load script I am creating these variables :
vLast3MonthStartDate=Monthstart(today(),-4);
vLastMonthEndDate=MonthEnd(Today(),-1);
I have a date field in my data called [Date]
I am trying to select the last 3 full months of data using this action on a button click :
= '>=' & $(vLast3MonthStartDate) & '<=' & $(vLastMonthEndDate)
But it doesn't seem to select anything.
I am clearing Date as the first action
Can anyone help?
Thanks,
Phil
Try this?
= '>=' & vLast3MonthStartDate & '<=' & vLastMonthEndDate
Or
= '>=' & $(=vLast3MonthStartDate) & '<=' & $(=vLastMonthEndDate)
Hi Try like this:
SUM({< DATE={"$(='>=' & $(vLast3MonthStartDate)& '<=' & $(vLastMonthEndDate))"}>}SALES)
hi,
Check your date field format and your variable format. you can change the format using date function..
vLast3MonthStartDate=Date(Monthstart(today(),-4));
vLastMonthEndDate=Date(MonthEnd(Today(),-1));