Want to convert Int (20140122) to Date 2014-01-22

[#1]

Hi All,

I have a column DATE_KEY which stores value as integer in format 20140122 (YYYYMMDD) and I want to convert this to Date 2014-01-22 in QlikView.

Please help me out.

Thanks in advance.

[tresesco · Accepted solution]

Try like:

Date(Date#(DATE_KEY, 'YYYYMMDD') , 'YYYY-MM-DD')

[#3]

hi

try this

date(date#(DATE_KEY,'YYYYMMDD'),'YYYY-MM-DD')

[#4]

Thanks Guys. It is working perfectly.

How to Concatenate below 2:

date(date#(DATE_KEY,'YYYYMMDD'),'YYYY-MM-DD') and Time(Time#(TIME_KEY,'HHMMSS'),'HH:MM:SS')

?

I need out as TXN_TIMESTAMP by adding Date and Time Part.

[#5]

HI

TRY THIS

date(date#(DATE_KEY,'YYYYMMDD'),'YYYY-MM-DD') & Time(Time#(TIME_KEY,'HHMMSS'),'HH:MM:SS')

[#6]

HI

date(date#(DATE_KEY,'YYYYMMDD'),'YYYY-MM-DD') &' '& Time(Time#(TIME_KEY,'HHMMSS'),'HH:MM:SS')

[#7]

Hi Kumar

It worked. Thanks.

date(date#(DATE_KEY,'YYYYMMDD'),'YYYY-MM-DD') &' '& Time(Time#(TIME_KEY,'HHMMSS'),'HH:MM:SS')