In some configurations, it's necessary to identify the latest date entered across multiple entries in a repeatable question group. This is useful in workflows where you need to calculate end dates, trigger validations, or control the visibility of sections based on the most recent event or timeline.
The method below outlines how to calculate the maximum date using standard functions and formula questions.
How to Configure the Max Date Logic
In a regular question group, create a base date question. This date will serve as the reference point for all calculations.
In the repeatable question group, add a formula question that calculates the number of days between the base date and the selected date in that row.
Back in the regular question group, create a formula question using the MAX_IN_GROUP() function to extract the maximum number of days from all repeatable entries.
Finally, add a formula date question that adds the maximum number of days to the base date, effectively reconstructing the latest date across all rows.
