Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
sahajaqlik
Contributor

Datef ormat

Hi all,

 I have Date as   201908, I want to show as Aug-2019, How to show

Labels (1)
2 Replies
Highlighted
Ezir
Contributor II

Re: Datef ormat

Hello @sahajaqlik ,

 

Try this:

monthname(date#(date,'YYYYMM'))

 

Regards,

 

Ezir 

Highlighted
Ezir
Contributor II

Re: Datef ormat

Hello @sahajaqlik 

 

You can try this

 

Replace(Capitalize(monthname(date#(date,'YYYYMM'))),' ','-')

 

 

Regards,

 

Ezir