Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have to set variable for the following expression
'>=$(=Date(MonthStart(vMaxSalesDate)))<=$(=Date(vMaxSalesDate))'
when i give like
vCurrMnth='>=$(=Date(MonthStart(vMaxSalesDate)))<=$(=Date(vMaxSalesDate))'
it is giving error.
Pls help me to solve this
Hi,
Monthyear is like MMM YYYY (jun 2015)
ok i removed it and used date alone.
date format is DD/MM/YYYY.
but still null values.
Any other suggestions plssssssssssss
Sorry I misread your earlier expression, it was correct if Date is DD/MM/YYYY then you had it right. Only other thing I can think of is to try it like this:
=SUM({<MonthYear=, Date={"$(vCurrMnth)"}>} DAYS)
showing garbage after '<='
Hahahaha damn it man. Try this I guess:
=SUM({<MonthYear=, Date={"$(='>=' & Date(MonthStart(vMaxSalesDate)) & '<=' & Date(vMaxSalesDate)))"}>} DAYS)
post your .qvw
or remove the label of your expression and try to find the problem looking at the popup as in image
Yes you can verify your output as mentioned by Massimo. I have created this kind of variable once, but as per my knowledge i simply wrote this as below
'>=$(=Date(MonthStart(vMaxSalesDate)))<=$(=Date(vMaxSalesDate))'
LET vCurrMnth=>=$(=Date(MonthStart(vMaxSalesDate)))<=$(=Date(vMaxSalesDate))
=SUM({<Date={"=$(vCurrMnth)"}>} DAYS)