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.

Not applicable

Monthname

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

eg;

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

how to get

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

3 Replies
jagannalla
Valued Contributor III

Re: Monthname

Try this:

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

Otherwise you can try

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

pgalvezt
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

HI

Try like this

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

returns oct 2001

hope it helps