Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am having trouble with getting an expression to work. Specifically, with the where clause:
{<Rev_Date = {">=$(vWeek7)<=date(vWeek7+6, 'DD/MM/YYYY'))"}>}
The first part: >=$(vWeek7) works correctly, as you can see from the screenshot below:
However, as you can see above, the second part: <=date(vWeek7+6, 'DD/MM/YYYY') is not working. I used this individual bit in another expression it works, where I only want to know data for week 7 + 6 days. However, when being used in this between expression, it is being ignored.
Can anybody offer insight into this?
Thanks
Hello,
You are just slightly mistaken there. Following is the way that will correctly implement the Date range in the Set Expression :
Aggr_Function({<date={">=$(=Date($(varMinDate))) <=($(=Date($(varMinDate)+6)))"}>} Fields)
Let me know if you have any queries about this.
Thanks & Regards.
Rohan S. Desai