Minus Datetime

[#1]

I have a trouble with minusing 2 datetime field. Can anyone help me to solve this problem, please? i will attached my file into this thread.

[sunny_talwar]

May be this:

=Interval(Sum(Aggr(ClosedDate-CreatedDate, CaseCode)), 'D hh:mm:ss')

[tresesco · Accepted solution]

I would avoid aggr() and use:

=Interval(Sum(ClosedDate-CreatedDate , CaseCode), 'D hh:mm:ss')

Corrected

[sunny_talwar]

I guess you are right . Just a minor correction though, you forgot to remove the aggregated dimension from my expression:

=Interval(Sum(ClosedDate-CreatedDate), 'D hh:mm:ss')

[HirisH_V7]

Hi,

May be like this,

Three expressions,

Interval(ClosedDate-CreatedDate,'DD')

Interval(ClosedDate-CreatedDate,'h')

Interval(ClosedDate-CreatedDate,'mm')

Hope this helps,

PFA,

Hirish

[#6]

Thank all very much