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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
davinfrost
Contributor III
Contributor III

adding +1 month on selected date

hi guys, i have a problem,

i have this

=Day(date(MonthStart(max(FilterDate)),'DD-MMM-YYYY'))

 

how to add month + 1 on that FilterDate ?

thanks

1 Solution

Accepted Solutions
davinfrost
Contributor III
Contributor III
Author

thank you so much !

i used this 

date(AddMonths(max(FilterDate),1),'DD-MMM-YYYY')

View solution in original post

2 Replies
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Try this:

Day(date(MonthStart(AddMonths(max(FilterDate),1)),'DD-MMM-YYYY'))

davinfrost
Contributor III
Contributor III
Author

thank you so much !

i used this 

date(AddMonths(max(FilterDate),1),'DD-MMM-YYYY')