On a saved search, can you have a minimum of a date and a maximum of a date in a single column using a formula

AI generated answer (using internal Slack threads):

In a saved search, you can use a formula to get the minimum or maximum of two date fields in a single column. You can use the

CASE WHEN

statement or the

GREATEST

and

LEAST

functions. For example, to get the latest date between two date fields, you can use the following formula:

CASE WHEN {date1} > {date2} THEN {date1} ELSE {date2} END

This formula will compare the two date fields and return the latest date. Alternatively, you can use the

GREATEST

or

LEAST

functions to get the maximum or minimum value between a set of values. However, please note that the

MAX

and

MIN

functions only work in formulas for saved searches if you have a

SUM

,

MAX

or

MIN

summary type. As for adding a formula-based column as a filter in a saved search, it is possible but it can be a bit tricky. The formula date filter will only work on the first formula column in the list, so you need to set your formula date before all other formula columns in the results tab. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******