Min/max date using table calcs

Knowledge Drop

Last tested: Mar 29, 2021

How can I get min/max date of a date range using table calcs? If you include the date field in the results, and sort desc:

Use this to get the max date: index(${date_field},1)

Use this to get the min date: index(${date_field}, max(row()))