×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

How to grab highest value only. Date conversion.

How to grab highest value only. Date conversion.

(OP)
I have 8 sections in a report. Each section has it's own Created datetime field and a Modified datetime field. In section 1, I can create a formula of CurrentDateTime-{SafetyReportA.ModifiedDate}, which shows me how long it's been since this section has been updated.

To keep in simple, Section 2 is the same CurrentDateTime-{SafetyReportB.ModifiedDate} along with Sections 3 to 8.

At first, I created a formula as:
(CurrentDateTime-{SafetyReportA.ModifiedDate} + CurrentDateTime-{SafetyReportB.ModifiedDate})/2
I could have did the same for all sections and divide in by 8 instead. However, that does not reach my goal.

How can I evaluate all 8 sections and then give one correct answer of the last time the entire report was last modified. In theory, I could evaluate all 8 Modified dates and go with the lowest whole number result of CurrentDateTime-{SafetyReport?.ModifiedDate}. Is there an easy way evaluate all 8 ModifiedDate?

TIA

RE: How to grab highest value only. Date conversion.

Assuming there are 8 separate modified date fields and that these are not located in subreports, you can just create a formula:

maximum([{SafetyReportA.ModifiedDate},{SafetyReportB.ModifiedDate},{SafetyReportC.ModifiedDate},{SafetyReportD.ModifiedDate},{SafetyReportE.ModifiedDate},{SafetyReportF.ModifiedDate},{SafetyReportG.ModifiedDate},{SafetyReportH.ModifiedDate}])

-LB

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!