Skip to main content
Question

Formula to show earliest date in a report?

  • March 22, 2018
  • 0 replies
  • 50 views
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!!

      • ChrisChris
      • Registered
      • March 22, 2018

      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]

      Ah, thank you so much!!! 
      Terms & ConditionsAccessibility statement