topic Re: Date formatting issue in QlikView

Date formatting issue

gilldilpreet — Tue, 03 Sep 2019 07:42:09 GMT

Hi,

I have set the date format in the script (see attached) but when I add the date fields to the dashboard as a text object they don't seem to be formatted correctly (see attached). Any ideas on what the issue might be here?

I would like to fix the problem in the script rather than have to reformat each individual object containing a date in the dashboard...

Many thanks

Dilpreet

Re: Date formatting issue

agigliotti — Tue, 03 Sep 2019 07:48:40 GMT

do as below in the script:

date(fieldName, '$(DateFormat)') as fieldName

Re: Date formatting issue

marcus_sommer — Tue, 03 Sep 2019 11:14:51 GMT

Any calculation with a date will remove the formatting and return a pure number. This means you will need to format it again usually by wrapping it within a date(), like:

date(max(DateField)) or date(today()-1) and similar cases.

- Marcus

Re: Date formatting issue

Brett_Bleess — Wed, 11 Sep 2019 16:43:51 GMT

Dilpreet, just giving you some additional links that may help you in addition to the two posters. If any of them got you what you needed, be sure to come back and use the Accept as Solution button on their post(s) to give them credit and let others know the suggestion worked.

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/date-time-interpretation.htm

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm

https://community.qlik.com/t5/Qlik-Design-Blog/Why-don-t-my-dates-work/ba-p/1465849

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

Regards,
Brett