RE: 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:
Is MAX() not the correct function to use?
Thanks!
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.
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