Converting this string into Date Time

[#1]

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

[#2]

Sorry.  Correction.  That would 10/24/2012 12:20

[swuehl]

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

[#4 · Accepted solution]

Thank you Stefan.  That works great!