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:

Saved SearchSaved Search

Is MAX() not the correct function to use?

Thanks!

frank33210 Rookie Asked on February 26, 2021 in Saved Searches.
Add Comment
1 Answers

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.

Hello, probably a bit late.

But from my experience with the MAX() and MIN() summary formulas. They are only displayed if the search itself is a summary type.

What I mean by this is that you would need to add a Summary type on one of the other columns. (Group, Average, Max, Min)

Not sure if this is helpful

 

If it is helpful, you might run into problems with the way you have written the formula. normally for netsuite if you want to display multiple items next to each other (IE you want to display a number then a word like 56 and DOLLARS, you will need to use a CONCAT formula, example: CONCAT(56,”DOLLARS”), so for your example you would need to do the following.

CONCAT(DATE1, CONCAT(DATE2,DATE3))

It allows a maximum of 2 combines per formula, thats why you stack it.

on August 1, 2022.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.