Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

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

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.

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

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

Try like:

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

View solution in original post

6 Replies
MVP
MVP

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

Try like:

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

View solution in original post

Not applicable

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

hi

try this

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

Not applicable

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

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.

Not applicable

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

HI

TRY THIS

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

Not applicable

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

HI

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

Not applicable

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

Hi Kumar

It worked. Thanks.

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