Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
anjali0108
Partner - Creator III
Partner - Creator III

how to change date format

Hi, The data i have has the field 'Time period ' in the following format :- Tue, Dec 31 10:15 PM .

How can i change its format to create the master calendar ..

Any suggestions .

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

Hi Anjali,

I'm missing the year there, but you can try the following

Date(Today(), 'WWW, MMM DD hh:mm TT')

And should see the returning value with the same format as you mention.

Miguel

View solution in original post

3 Replies
Miguel_Angel_Baeyens

Hi Anjali,

I'm missing the year there, but you can try the following

Date(Today(), 'WWW, MMM DD hh:mm TT')

And should see the returning value with the same format as you mention.

Miguel

Not applicable

Hi,

You can try this script.

Date(Date#(Time period, 'WWW, MMM DD hh:mm TT'),'MM-DD hh:mm')    as period

Not applicable

Hiii

try this expressions

1) SET DateFormat='DD-MM-YYYY';

2) date(today(),'MM-DD-YYYY') = 01-04-2015