Solved: How to find monthname from monthnumber - Qlik Community

Anonymous · ‎2015-07-22

Hi Genuises,

I have to find the monthname of the month lying two months back from todays date

I am using the formula =month(Today())-2), it gives me as 5 but I want this five to be displayed as May.

I want all this to be implemented in the script.

Thanks,

Shashank

MayilVahanan · ‎2015-07-22

Hi

Try like this

=Month(Floor(AddMonths(Today(),-2)))

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

MayilVahanan · ‎2015-07-22

Hi

Try like this

=Month(Floor(AddMonths(Today(),-2)))

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

Anonymous · ‎2015-07-22

Thanks a lot Boss

sasiparupudi1 · ‎2015-07-22

Month(AddMonths(Today(),-2))

How to find monthname from monthnumber