Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

shashank20
New Contributor III

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

Tags (1)
1 Solution

Accepted Solutions

Re: How to find monthname from monthnumber

Hi

Try like this

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

3 Replies

Re: How to find monthname from monthnumber

Hi

Try like this

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

shashank20
New Contributor III

Re: How to find monthname from monthnumber

Thanks a lot Boss

sasiparupudi1
Honored Contributor III

Re: How to find monthname from monthnumber

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

Community Browser