Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
PrashantRupani
Creator
Creator

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

1 Solution

Accepted Solutions
m_woolf
Master II
Master II

=date(today(),'Your desired format here')

Ex: =date(today(),'DD/MM/YYYY') will return 22/05/2019

View solution in original post

2 Replies
m_woolf
Master II
Master II

=date(today(),'Your desired format here')

Ex: =date(today(),'DD/MM/YYYY') will return 22/05/2019

PrashantRupani
Creator
Creator
Author

Thank you. This worked.