Forum Discussion

ElenaLarrabee1's avatar
ElenaLarrabee1
Qrew Captain
7 years ago

Formula to show earliest date in a report?

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's avatar
    ChrisChris
    Qrew Assistant Captain
    7 years ago

    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]