topic Re: Convert minutes to date in QlikView

Convert minutes to date

Fri, 12 Jun 2015 12:17:48 GMT

Hello all,

I have a field containing number of minutes strarting from a date. I want to have this field as a timestamp.

Field Timestamp

727519 01/05/2015 05:19

Thank you if u have any clue

Re: Convert minutes to date

sunny_talwar — Fri, 12 Jun 2015 12:22:24 GMT

What is the starting date in your case?

Re: Convert minutes to date

Fri, 12 Jun 2015 12:25:39 GMT

I only know that 727519 corresponde to this date 01/05/2015 05:19.
I can say that in field2=field1-727519 the start date is 01/05/2015 05:19.

Re: Convert minutes to date

sunny_talwar — Fri, 12 Jun 2015 12:26:40 GMT

Assuming your date to be in this format: DD/MM/YYYY, the starting date seems to be 12/12/2013. Try this in a text box if its true:

=Timestamp#(Date(Date#('12/12/2013', 'DD/MM/YYYY') + Floor(Interval#('727519', 'mm')), 'DD/MM/YYYY') & ' ' & Interval(Frac(Interval#('727519', 'mm')), 'hh:mm'), 'DD/MM/YYYY hh:mm')

HTH

Best,

Sunny

Re: Convert minutes to date

m_woolf — Fri, 12 Jun 2015 12:27:16 GMT

I gather that your start date is 8/18/2013

StartDate + Field/60/24 as TimeStamp

Re: Convert minutes to date

sunny_talwar — Fri, 12 Jun 2015 12:32:58 GMT

Awesome

I made a simple thing so much more complicated with my solution. I was just checking how your solution works and I guess to get him what he is looking for (in the format he is looking for), I added the TimeStamp() function around it:

=Timestamp(Date#('8/18/2013', 'MM/DD/YYYY') + 727519/(60*24), 'MM/DD/YYYY hh:mm')

Re: Convert minutes to date

Fri, 12 Jun 2015 12:35:25 GMT

thank you for the answer

Re: Convert minutes to date

Fri, 12 Jun 2015 12:35:37 GMT

thank you a lot !

Re: Convert minutes to date

sunny_talwar — Fri, 12 Jun 2015 12:36:51 GMT

I am glad we were able to help, but I think the answer came from mike woolf‌, you should reward him for the correct answer (and reward me with a helpful answer if you like )

Re: Convert minutes to date

Fri, 12 Jun 2015 12:45:02 GMT

You are right, thank you both and all the community members who share knowledge