topic Re: how to change date format in QlikView

how to change date format

anjali0108 — Thu, 02 Apr 2015 10:50:57 GMT

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 .

Miguel_Angel_Baeyens — Thu, 02 Apr 2015 11:36:23 GMT

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

Thu, 02 Apr 2015 13:07:45 GMT

Hi,

You can try this script.

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

Thu, 02 Apr 2015 13:15:22 GMT

Hiii

try this expressions

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

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