Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I would avoid aggr() and use:
=Interval(Sum(ClosedDate-CreatedDate , CaseCode), 'D hh:mm:ss')
Corrected
May be this:
=Interval(Sum(Aggr(ClosedDate-CreatedDate, CaseCode)), 'D hh:mm:ss')
I would avoid aggr() and use:
=Interval(Sum(ClosedDate-CreatedDate , CaseCode), 'D hh:mm:ss')
Corrected
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')
Hi,
May be like this,
Three expressions,
Interval(ClosedDate-CreatedDate,'DD')
Interval(ClosedDate-CreatedDate,'h')
Interval(ClosedDate-CreatedDate,'mm')
Hope this helps,
PFA,
Hirish
Thank all very much