Calculate a Time Interval Between Two Dates

daskas27
daskas27 used Ask the Experts™
on
Hello, I have a report that I would like to find the time interval between two dates. The first is a flat date field, the second is a summary field that is showing me the largest date of another field. Is it possible to calculate the time interval in days between these two dates? I ahve attached an example copy of the report for reference.

Thank you
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
I don't see the attachment.

It should be.

How are you getting the max date?

mlmcc
daskas27IT manager

Author

Commented:
I have re-uploaded the example report
Date2.rpt
IT manager
Commented:
The answer to this was;

DateDiff("d", {tcstvhdr.thadddte}, NthLargest (1, {tcstvdet.tdfdte}, {tcstvhdr.threl}))

Thank you

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial