Trouble with retrieving a date between two variables

[dbfg]

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

[Rohan]

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