Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've Current month start variable = vCurrentMonthStart
and Today's date variable = vToday.
Using this how to get the date values in between that is "Current Month to Date"
I tried the following expression please correct me.
sum({1<[PostingDate]={">=$(=date(vCurrentMonthStart) <= $(=date(vToday))"}>} DeliveredQty)
One bracket correction might do the job:
sum({1<[PostingDate]={">=$(=date(vCurrentMonthStart)) <= $(=date(vToday))"}>} DeliveredQty)
SUM({<PostingDate = {">=$(=MonthStart(Today()))<=$(=Today())"}>}DeliveredQty)
Define your vCurrentMonthStart as
=Date(MonthStart(Today()))
Now you can use as below
=SUM({<PostingDate = {">=$(vCurrentMonthStart)<=$(=Today())"}>}DeliveredQty)
One bracket correction might do the job:
sum({1<[PostingDate]={">=$(=date(vCurrentMonthStart)) <= $(=date(vToday))"}>} DeliveredQty)
As tresesco says, you are missing a bracket..
sum({1<[PostingDate]={">=$(=date(vCurrentMonthStart)) <= $(=date(vToday))"}>} DeliveredQty)
Make sure that your posting date is in the same format as the dates in your variable.
HTH
Sasi