MonthStart & Today() - Substracting days

[Anonymous]

Hi all

I hope someone can help me.

I have below expression, where I'm trying to substract XX numbers of days from MonthStart of Today().

However it doesn't return the correct amount. It seems like it's including to many days.

Sum({$<BOOKING_DATE = {">=$(=MonthStart(TODAY() - 16)) <=$(=MonthStart(TODAY())))"}>} NET)

So basically I'm trying to get this date range e.x [15-09-2017] - [01-10-2017].

Thanks.

Regards

Stefan

[Anil_Babu_Samineni · Accepted solution]

Does this works?

Sum({<BOOKING_DATE = {"=BOOKING_DATE >= MonthStart(Today())-16 AND BOOKING_DATE <= MonthStart(Today())"}>} NET)

Note - Make sure about Date format for BOOKING_DATE and Today(). Try to check using text box..

[RonaldDoes]

MonthStart(TODAY() - 16)

will do just that, give you the MonthStart for the date 16 days ago (so for the first 16 days of the month, the monthstart of the previous month, and from the 17th of each month, just the montstart of the current one).

What you want here is:

MonthStart(Today())-16

[Anonymous]

Hi Anil

That was "easy".

And yes it works perfectly.

Thanks a lot.

[Anonymous]

Hi Ronald

Yes of course. That makes sense. It's all about the parenthesis.

Thanks for the answer. I will keep that in mind.