Rest of the Month Flag

[satishkurra]

Hi

I currently have a requirement to show the plan from today to the end of the month.

Example: Plan should be display from Today 08/19/2016 to End of Month 08/31/2016.

I had written the expression on UI as

Sum({<Date={">=$(=Today())<=$(=MonthEnd(Today(),0))"}>}Plan)

I'm just thinking of a way to write this in flags on script level.

Can someone help me in achieving this?

Thanks

Satish

[sunny_talwar · Accepted solution]

Try this may be:

LOAD DateField:

          If(DateField >= Today() and DateField <= MonthEnd(Today()), 1, 0) as Flag

FROM .....

and then just do

Sum({<Flag = {1}>} Plan)

[Anonymous]

Is it OK to use where condition?

Select * from table_name

where  date_field > Today() and date_field< MonthEnd(Today(),0)

[Anonymous]

Cool idea.