topic Need help on date format in QlikView

Need help on date format

apoorvasd — Fri, 24 Aug 2018 05:36:28 GMT

Hello Everyone,

I need help in getting the desired date format in my QV application. I have created a date field in my script using the below code

Date(WeekStart(today())-2,'MMM DD, YYYY'), this would give me the previous Friday date. The format that I want this date to be in is,

MMM DD, YYYY (ex., Aug 24, 2018). I am able to see this format in my straight table. But when I export the table to excel file, the format changes (to 8/24/2018) but, I want to have the same format when exported to excel file too. How can I change my code to fit in this format?

Any help on this?

Thank you.

Re: Need help on date format

tamilarasu — Fri, 24 Aug 2018 05:46:00 GMT

Try,

Text(Date(WeekStart(today())-2,'MMM DD, YYYY'))

Re: Need help on date format

apoorvasd — Fri, 24 Aug 2018 06:06:28 GMT

Hello,

Works! Thank you.

Small clarification, this field will not be recognized as date and would be interpreted just as a normal text, is that right?

Re: Need help on date format

tamilarasu — Fri, 24 Aug 2018 06:10:42 GMT

Yes. We are converting the date into text format in QlikView. Excel will treat this as text format like other text fields. You can check this after exporting it into excel.

Re: Need help on date format

apoorvasd — Fri, 24 Aug 2018 06:12:01 GMT

Okay, thank you.

Re: Need help on date format

tamilarasu — Fri, 24 Aug 2018 06:14:02 GMT

No problem. Have a good day!