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