Datef ormat

[qlikapple]

Hi all,

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

[Ezir]

Hello @qlikapple ,

Try this:

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

Regards,

Ezir 

[Ezir]

Hello @qlikapple 

You can try this

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

Regards,

Ezir

[Brett_Bleess]

I believe the previous poster got you what you needed, if so, please do not forget to close out your thread by using the Accept as Solution button on the post that got you what you needed.  I am including a couple of other links for you as well that may further help.

https://community.qlik.com/t5/Qlik-Design-Blog/The-Date-Function/ba-p/1463157

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/DateA...

If you still have further questions, please leave an update post.

Regards,
Brett