Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Convert dates

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

3 Replies
celambarasan
Not applicable

Convert dates

Hi,

     Use MakeWeekDate() funcrtion

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

Hope it helps

Celambarasan

jagan
Not applicable

Convert dates

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.

Not applicable

Convert dates

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