AnsweredAssumed Answered

use of Max () Function

Question asked by Scorpion167 on Feb 8, 2018
Latest reply on Oct 28, 2018 by beverly

All,

 

I'm working on a script to Find and Sort a Product table to be viewed in a layout that has summary fields. The Sort is by Product name and Order ID. What I'd like to do next is use the MAX() function to determine the most current Date for each Product and have a single instance of that Product with the Date display in the layout.

 

I've found information in the Community Database (MAX Date? by Stu412 on Mar 19, 2015) which was answered by Philmodjunk, it looks to be what I'm looking for.  But I'm still having problems with the script.

 

What I need help with is getting a better understanding of where MAX() needs to be.

 

Thanks

Outcomes