Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Partner - Champion
Partner - Champion

Hi,

     Use MakeWeekDate() funcrtion

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

Hope it helps

Celambarasan

jagan
Luminary Alumni
Luminary Alumni

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
Author

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