Formula to show earliest date in a report?

  • 0
  • 1
  • Question
  • Updated 8 months ago
  • Answered
  • (Edited)
Hi all, trying to create a date/time (formula) field to show me the earliest date/time out of a related/embedded report. We have events that often have multiple dates/times, so I created a related table (event dates) and put a grid report on the main event form, and I just want one field to show me the earliest date and time from the related report. Any help is greatly appreciated!!
Photo of Elena Larrabee

Elena Larrabee

  • 736 Points 500 badge 2x thumb

Posted 8 months ago

  • 0
  • 1
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb

Your summary field in the parent table would summarize the "minimum" of the specified date field.

Summary of a specific field { Maximum } of the [Date Field]

or the { Minimum } of the [Date Field]

(Edited)
Photo of Elena Larrabee

Elena Larrabee

  • 736 Points 500 badge 2x thumb
Ah, thank you so much!!!