Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to find monthname from monthnumber

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

1 Solution

Accepted Solutions
MayilVahanan

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.

View solution in original post

3 Replies
MayilVahanan

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
Not applicable
Author

Thanks a lot Boss

sasiparupudi1
Master III
Master III

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