topic Re: interval between dates in QlikView

interval between dates

Wed, 25 Nov 2020 16:16:04 GMT

Hello to all.
How can I calculate the differe between two dates in minutes. The date format is of the type DD / MM / YYYY hh: mm: ss?
I tried the instruction:

interval (# timestamp (departure, 'DD / MM / YYYY hh: mm: ss') - # timestamp (arrival, 'DD / MM / YYYY hh: mm: ss'), 'hh')

but does not work

Thank you all

Re: interval between dates

sunny_talwar — Thu, 27 Oct 2016 10:33:15 GMT

May be like this:

Interval(TimeStamp#(departure, 'DD / MM / YYYY hh: mm: ss') - TimeStamp#(arrival, 'DD / MM / YYYY hh: mm: ss'), 'mm')

Do you have these extra spaces between DD and MM? I mean do you have this

15 / 10 / 2016 10: 38: 00

or do you have this?

15/10/2016 10:38:00

If later, then try this:

Interval(TimeStamp#(departure, 'DD/MM/YYYY hh:mm:ss') - TimeStamp#(arrival, 'DD/MM/YYYY hh:mm:ss'), 'mm')

Re: interval between dates

Thu, 27 Oct 2016 10:41:49 GMT

hi Sunny.

Sorry. But do not have extra spaces between spaces between DD and MM.

thank

Re: interval between dates

sunny_talwar — Thu, 27 Oct 2016 11:02:04 GMT

So did my second suggestion worked? or are you still having issues?

Re: interval between dates

Thu, 27 Oct 2016 11:14:57 GMT

Yes. I tried your second suggestion, but it did not work.

Then I tried this statement:
interval (time (departure) - time (arrival), 'mm')
and it seems to work.

what do you think about it?

thank you

Re: interval between dates

sunny_talwar — Thu, 27 Oct 2016 11:17:17 GMT

I think if you departure and time are already read as date, we don't need to use TimeStamp#() function. So, I think you are in good shape there

Re: interval between dates

swuehl — Thu, 27 Oct 2016 11:18:29 GMT

Time() is a formatting function, which you don't need if you format with interval():

interval ( departure -arrival, 'mm')

edit: Read more about Formatting vs. Interpretation functions:

The Date Function

Re: interval between dates

susovan — Thu, 27 Oct 2016 11:41:41 GMT

Hi Marino,

May be like this,

Interval(TimeStamp(departure, 'DD / MM / YYYY hh: mm: ss') - TimeStamp(arrival, 'DD / MM / YYYYhh: mm: ss'), 'mm')