Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


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.

Not applicable


usually monthname will get you 'MMM YYYY', how can it be done if we want the format to be MMM-YY?


monthname ( '2001-10-19' ) returns 'Oct 2001' - by default

how to get

'Oct-01' instead of 'Oct 2001'.

3 Replies
Valued Contributor III

Re: Monthname

Try this:

=Date(monthname ( '2001-10-19' ),'MMM YY')

Otherwise you can try

=Date('2001-10-19' ,'MMM YY')

Valued Contributor

Re: Monthname

Hi, Go to properties - Tab Number (Format) - Date (Yo can change the format date in this option)

Hope Help you!

Re: Monthname


Try like this

=Date(monthname ( '2001-10-19' ),'MMM YYYY')

returns oct 2001

hope it helps