Saved Search: Maximum of date fields on a record?

Hello,

We track three dates for each PO detail line: the expected receipt date, along with two custom columns to track vendors’ committed delivery dates.  I am trying to use the MAX() function within a saved search to display the latest of these three dates, but the column is not displaying in the search results.  This is the column labeled “Max” in the picture:

Saved SearchSaved Search

Is MAX() not the correct function to use?

Thanks!

Rookie Asked on February 26, 2021 in Saved Searches.
Add Comment
1 Answer(s)

max tells you the max across the same column in different records.  You’ll want to use an if-then or case-when statement instead.

Rookie Answered on February 26, 2021.

Hi 2ps,

From what I understand, CASE-WHEN is used when branching logic based on a single variable.  Here I have three fields to pick the highest from.  What would that look like?

Thanks

on February 26, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor