topic Re: Datef ormat in QlikView

Datef ormat

qlikapple — Sat, 16 Nov 2024 01:16:51 GMT

Hi all,

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

Re: Datef ormat

Ezirraffner — Fri, 14 Feb 2020 12:02:05 GMT

Hello @qlikapple ,

Try this:

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

Regards,

Ezir

Re: Datef ormat

Ezirraffner — Fri, 14 Feb 2020 12:07:05 GMT

Hello @qlikapple

You can try this

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

Regards,

Ezir

Re: Datef ormat

Brett_Bleess — Wed, 11 Mar 2020 17:58:33 GMT

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/DateAndTimeFunctions/date-time-functions.htm

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

Regards,
Brett