Set Analysis "Current Month to Date" Question.

[MuraliPrasath]

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)

[MK_QSL]

SUM({<PostingDate = {">=$(=MonthStart(Today()))<=$(=Today())"}>}DeliveredQty)

[MK_QSL]

Define your vCurrentMonthStart as

=Date(MonthStart(Today()))

Now you can use as below

=SUM({<PostingDate = {">=$(vCurrentMonthStart)<=$(=Today())"}>}DeliveredQty)

[tresesco · Accepted solution]

One bracket correction might do the job:

sum({1<[PostingDate]={">=$(=date(vCurrentMonthStart)) <= $(=date(vToday))"}>} DeliveredQty)

[sasiparupudi1]

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