Min/max date using table calcs

[sarah_tayeri]

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()))

This content is subject to limited support.