sum and rest date time

[fkeuroglian]

Hi expert

I want to know rest date time format

for example i attached a qvw where i have CreateDate and complete date,  i want to rest CompletedDate - CreatedDate and get the result in HOURS

thank you a lot

Fernando

[its_anandrjs · Accepted solution]

Hi,

Try this way in any straight chart

Interval(COMPLETEDDATE - CREATEDATE,'hh')

Regards

Anand

[fkeuroglian]

Thank you Anand, and to add the minutes?

[Anonymous]

hh:mm

hh:mm:ss

Don't use MM - it is months, not minutes

[its_anandrjs]

Hi,

Then try

Interval(COMPLETEDDATE - CREATEDATE,'hh:mm:ss')

or

Interval(COMPLETEDDATE - CREATEDATE,'hh:mm')

Or

Interval(COMPLETEDDATE - CREATEDATE,'hh')

Yes do not use capital words like MM it is for Months.

Regards

Anand