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: 
knightwriter
Creator III
Creator III

Month name change

Hi All,

Quick and easy one for you! I have the months of the year as list box properties. My months are showing as Jan-14, Feb-14 etc, how do I change this to show Jan, Feb etc without manually changing all these in my excel spreadsheet.

Many thanks,

Stephen

6 Replies
senpradip007
Specialist III
Specialist III

Try this

Date(Date#('Jan-14','MMM-YY'),'MMM')

ashfaq_haseeb
Champion III
Champion III

Hi,

May be like this.

=left('Jan-14',3)

Regards

ASHFAQ

Anonymous
Not applicable

Try this:

In the script

Month(Fieldname)

tresesco
MVP
MVP

I recommend: =Month(Date#(YourField , 'MMM-YY'))

This gives you output which is responsive to all date functions.

knightwriter
Creator III
Creator III
Author

Hi tresesco,

Where do I use this formula? The script or excel?

Thanks

Anonymous
Not applicable

In the Script level...