Date formatting issue

[gilldilpreet]

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

[agigliotti]

do as below in the script:

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

[marcus_sommer · Accepted solution]

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

[Brett_Bleess]

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-...

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

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