Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
raadwiptec
Creator II
Creator II

month

I need data for Previous month plus current month until today?  any suggestion

12 Replies
sunny_talwar

Used the following expression for search string:

='>=' & Date(MonthStart(Today(), -1)) & '<=' & Date(MonthEnd(Today()))

raadwiptec
Creator II
Creator II
Author

hi sunny, but it should not be until 31st  mar..it should until today

sunny_talwar

You can change the search expression as you would want,

='>=' & Date(MonthStart(Today(), -1)) & '<=' & Date(Today())