Set Expression for Date Range

[khanashique]

Hi Experts,

Sample data file is attached from where i have to set an expression which will give me total sales of value between days.

Below are the examples which i have set the expressions, but it does not return the value that is expected.

sum({<MONTH= {"$(=getfieldselections(MONTH))"},DAY = {'>=$(vStartDate) <=$(vToday)'}>}SALES)

sum({<MONTH= {"$(=getfieldselections(MONTH))"},DATE = {"$(= '>=' & date(vStartDate) & '<=' & date(vToday))"}>}SALES)

Example: Total current months sales for last year is 77k but i need to see the sales till date for last year (1dec2017 - 18dec2017) which is 48K.

Thanks,

MAK.

[OmarBenSalem · Accepted solution]

Try : 

For MTD of last year

sum({<Year, Month, Date={"<=$(=date(addyears(today(1),-1)))>=$(=date(addyears(monthstart(today(1)),-1)))"}>}Value)

[khanashique]

Thanks Omar, it worked...