Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this?
= Ceil(Interval(MonthEnd(Today()) - Today(), 'd'))
Hello I created a variable with the function but the idea would be this,
LET vData = Ceil(MonthEnd(Today()) - Today())-1;
Best Regards
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.