topic adding +1 month on selected date in QlikView

adding +1 month on selected date

davinfrost — Wed, 25 Nov 2020 16:16:04 GMT

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

Arthur_Fong — Tue, 24 Sep 2019 03:16:17 GMT

Try this:

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

davinfrost — Tue, 24 Sep 2019 03:28:26 GMT

thank you so much !

i used this

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