Knowledge Drop

Min/max date using table calcs

  • 7 July 2021
  • 0 replies
  • 94 views

Userlevel 1

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.                

 

 


0 replies

Be the first to reply!

Reply