Aggregate Filters API

[iwells]

Possibly the question I'm asking best suited to use CS0120, but using .Browse is there a way to find the max and min values?

For example, if I'm browsing CSCRD and I want the max rate date for a specific currency. Just trying to understand if there's functionality I'm not aware of and how others are doing this.

 

[ettienne]

Simplest is an SQL query using CS0120 "select max(field) blah blah"
Browsing the view (what you mean with using .Browse?) is not going to easily produce the same result.

Sage 300 Certified Consultant

 

[iwells]

Thanks, I was just curious if the way I was doing it (using CS0120) was correct or if there were some other simple ways of doing it that I was not aware of.