
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Date format of Today's date
Hello,
I am new to Qlikview and self-learning the tool.
I understand that if I use the expression = today() in a text object, it will display today's date as 5/22/2019.
Because in Edit Script, the format is set to -
SET DateFormat='M/D/YYYY';
But how to change the format of the date ? How to display the date like May 22, 2019 or 22/05/2019 or 22-MAY-2019?
I understand that I need to go back to edit script to change the format in SET DateFormat='M/D/YYYY'; But that will change the format of every date on the dashboard as SET DateFormat='M/D/YYYY'; is universal.
I just want to change the format of this date in text object.I tried clicking on Properties of the text object to find if I can change the format.But could not find any option.
I am also using Cognos BI tool wherein we have the flexibility to do so. Developer can set the date format of every object the way they want it. Trying to find in Qlikview.
Your help is appreciated.
Thanks
Prashant
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=date(today(),'Your desired format here')
Ex: =date(today(),'DD/MM/YYYY') will return 22/05/2019


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=date(today(),'Your desired format here')
Ex: =date(today(),'DD/MM/YYYY') will return 22/05/2019

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you. This worked.
