Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.