Calculate duration (creationdate - closuredate)

[#1]

Hello,

I'm trying to calculate the duration of creation and closure date.

Tried the following:

SQL SELECT
datumaangemeld                                          AS IN_DATE_creation_date
datumafgemeld                                                  AS IN_DATE_closure_date,
datumafgemeld - datumaangemeld                       AS IN_DATE_duration,
FROM db; 

Above code is not working, any suggustions?

I would like to have the data stored as hours:mins:seconds

Thanks!

Screenshot seems not to be working so here table information:

IN_DATE_creation_date	IN_DATE_closure_date
10/29/2004 9:54:00 PM	10/29/2004 9:59:01 PM
10/30/2004 10:00:00 PM	10/30/2004 10:11:01 PM

[nagaiank]

Try the following:

LOAD datumaangemeld            AS IN_DATE_creation_date

          datumafgemeld                  AS IN_DATE_closure_date,

          datumafgemeld - datumaangemeld AS IN_DATE_duration;

SQL SELECT

datumaangemeld

datumafgemeld

FROM db;

Displaying the duration in hh:mm:ss can be achieved by specifying the format in the 'Number' tab of chart properties.

[#3]

Screenshot was not working here table information:

IN_DATE_creation_date	IN_DATE_closure_date
10/29/2004 9:54:00 PM	10/29/2004 9:59:01 PM
10/30/2004 10:00:00 PM	10/30/2004 10:11:01 PM

[#4]

Just tried it, looks working; Altough when a duration longer then 24 hours its not working correlty anymore.

[nagaiank · Accepted solution]

For the duration field, in the Number tab, chose interval format 'dd hh:mm:ss'

[#6]

Thank you, works! also my old code works with just the field adjustments.