Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Re: Converting this string into Date Time

Thank you Stefan.  That works great!

3 Replies
Not applicable

Re: Converting this string into Date Time

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

MVP
MVP

Re: Converting this string into Date Time

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

Re: Converting this string into Date Time

Thank you Stefan.  That works great!

Community Browser