Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone. First posting.
I am wanting to convert this string (or could be numeric) into a qliview date/time format. 0:201212412200000:0.000000:0:0
Want to look like 10/24/2012 12:00 or even qlikview's numeric value will be fine as well.
Thank you very much
Mark
Thank you Stefan. That works great!
Sorry. Correction. That would 10/24/2012 12:20
If you've missed a zero inbetween your string (0:2012102412200000:0.000000:0:0)
I think you can do it like:
=Timestamp(Date#(mid('0:2012102412200000:0.000000:0:0',3,12),'YYYYMMDDhhmm'),'MM/DD/YYYY hh:mm')
resp.
=Timestamp(Date#(mid(YOURSTRINGFIELD,3,12),'YYYYMMDDhhmm'),'MM/DD/YYYY hh:mm')
Hope this helps,
Stefan
Thank you Stefan. That works great!