Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to convert Month Year Formate YYYY_MM into MMM-YYYY ?

Hi,

I am new to qlikview.

I have Month and Year in below formate.

2014_01

i would like to convert and show thisin below format using LOAD Statement.

Jan-2014

any help would be greatly appreciated.

3 Replies
Not applicable
Author

Hi,

Add the below within your load statement:

Load YourDateField,

date(date#(YourDateField, 'YYYY_MM'), 'MMM-YYYY') as dte2

from ...

Not applicable
Author


Great!.

it works.

Not applicable
Author

Glad to help Hailey

Kindly mark the answer as correct to close the thread.

Thx.