Discussions

Expand all | Collapse all

Formula to show earliest date in a report?

  • 1.  Formula to show earliest date in a report?

    Posted 03-22-2018 16:29
    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!!


  • 2.  RE: Formula to show earliest date in a report?

    Posted 03-22-2018 16:43

    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]



  • 3.  RE: Formula to show earliest date in a report?

    Posted 03-22-2018 16:49
    Ah, thank you so much!!!