Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try like:
Date(Date#(DATE_KEY, 'YYYYMMDD') , 'YYYY-MM-DD')
hi
try this
date(date#(DATE_KEY,'YYYYMMDD'),'YYYY-MM-DD')
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.
HI
TRY THIS
date(date#(DATE_KEY,'YYYYMMDD'),'YYYY-MM-DD') & Time(Time#(TIME_KEY,'HHMMSS'),'HH:MM:SS')
HI
date(date#(DATE_KEY,'YYYYMMDD'),'YYYY-MM-DD') &' '& Time(Time#(TIME_KEY,'HHMMSS'),'HH:MM:SS')
Hi Kumar
It worked. Thanks.
date(date#(DATE_KEY,'YYYYMMDD'),'YYYY-MM-DD') &' '& Time(Time#(TIME_KEY,'HHMMSS'),'HH:MM:SS')