How to display Days Remaining in Current Month?

[jlakehivewyre]

Hello Qlik Community,

This group has been very helpful, and once again, I have some questions.  This time, I want to know how to write an expression/formula to show how many days remain in current month. 

For example, I can dynamically show "Today" as an expression =Date(Today()), but how can I get it to also show me number of remaining days?  Including today. 

The answer I'd expect the expression to return would be 10; and when I would look tomorrow, it would dynamically update to 9, and so on. 

Thanks in advance.

[vishsaggi · Accepted solution]

Try this?

= Ceil(Interval(MonthEnd(Today()) - Today(), 'd'))

[giovanneb]

Hello I created a variable with the function but the idea would be this,

LET vData = Ceil(MonthEnd(Today()) - Today())-1;

Best Regards

[jlakehivewyre]

Thank you, this works like a charm, and outputs the correct days remaining.  I may end up creating a variable from it, so I can use it in a few different ways, but this is very helpful.