Date Format Problems

[anuradhaa]

Hi,

i'm new to Qlikview and i need to convert 'YYMMDD' date,( this is in as varchar in the database) to 'YYYY-MM-DD' format in Qlikview.

I have tried to_date function but it doesn't work.

Please help me to solve this Problem

[deepakk · Accepted solution]

HI Anuradha,

A small query. Since your data is in YYMMDD format eg 100202 for 2nd Feb 2010. but how will the system understand

10(YY) stands for 2010.

Do you have data only from 2000 ???? if yes the you can try out the below code.

Date(makedate('20'&left(SHIP_DATE,2),mid(SHIP_DATE,3,2), right(SHIP_DATE,2)),'YYYY-MM-DD') as SHIP_DATE

Deepak

[CELAMBARASAN]

Hi,

     Yes it will give you that date format only.Which format it returns now?

Celambarasan

[anuradhaa]

Thanks Deepak,

I have data only from 2000 and you answer helps me lot

Thanks