Date format

[renjithpl]

Hi All,

I have a date field where the date format has the following format, "06-Apr-2011 (Wed)", when loaded, qlikview reads this as text,

I need to create a calendar out of it.

I have tried certain methods like

(Subfield(Date, ' ', 1)) as Date,

//Year((Subfield(Date, ' ', 1))) as Year,

Date(Date#(Date, 'DD-MMM-YYYY (DDD)'), 'MM-DD-YYYY') as Date2,

//date(date#(Date,'DD-MMM-YYYY (DDD)'),'dd-MMM-yyyy') as Date1,

But nothing happening. I appreciate your help.

Regards
Renjith

[deepakk · Accepted solution]

hi,

try out this method.

Date(Date#(left(Field,11),'DD-MMM-YYYY'),'DD/MM/YYYY') as Date

Now you can use this date field for getting year, month, Week.