Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Converting this string into Date Time

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

1 Solution

Accepted Solutions
Not applicable
Author

Thank you Stefan.  That works great!

View solution in original post

3 Replies
Not applicable
Author

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

swuehl
MVP
MVP

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

Not applicable
Author

Thank you Stefan.  That works great!