topic Convert dates in QlikView

Convert dates

Fri, 17 Feb 2012 10:55:25 GMT

I am trying to convert a date that is formated as "YEARWEEKDAY" to "Year-MONTH-DAY" can anyone help me please!

CELAMBARASAN — Fri, 17 Feb 2012 11:01:23 GMT

Hi,

Use MakeWeekDate() funcrtion

Date(MakeWeekDate(Left(Date,4),Mid(DateField,5,2),Right(DateField,2)),'YYYY-MMM-DD')

Hope it helps

Celambarasan

jagan — Fri, 17 Feb 2012 11:14:05 GMT

Hi,

Try using the below expresion

Date(MakeWeekDate(Left(DateField,4),Mid(DateField,5,2),Right(DateField,2)),'YYYY-MMM-DD')

Hope this helps you.

Regards,

Jagan.

Fri, 17 Feb 2012 11:53:29 GMT

Hi,

You may also use the following expression:

date((Your_Date_Field_Name),'YYYY-MMM-DD') as NewDate

For example, if your date field has 22-04-2012, the above express will give 2012-APR-22.

Hope this helps.

Regards,

-Khaled