Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
jlakehivewyre
Contributor III
Contributor III

How to display Days Remaining in Current Month?

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.

1 Solution

Accepted Solutions
vishsaggi
Champion III
Champion III

Try this?

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

View solution in original post

3 Replies
vishsaggi
Champion III
Champion III

Try this?

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

giovanneb
Creator II
Creator II

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


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

Best Regards

jlakehivewyre
Contributor III
Contributor III
Author

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.