Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
do as below in the script:
date(fieldName, '$(DateFormat)') as fieldName
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
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://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