Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

PrashantRupani
New Contributor II

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
mwoolf
Honored Contributor II

Re: Date format of Today's date

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

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

2 Replies
mwoolf
Honored Contributor II

Re: Date format of Today's date

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

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

PrashantRupani
New Contributor II

Re: Date format of Today's date

Thank you. This worked.