Skip to Content
0

Why Is Max(Date) not returning the latest record in BO 3.x Infoview Report?

Oct 27, 2016 at 09:23 PM

12

avatar image

Hello Gurus,

I have a situation where I need to display the latest record using the Max(Date) function. Instead, the result I'm getting is the latest record for every category in the block. :-( I've tried a bunch of stuff with variables and filtering and then finally turned to google. Unfortunately, I've remained stuck.

So I have 3 fields: Est#, InspDate, StatCode. When I throw them in a table I get every record:

When I use Max(InspDate), instead of getting the latest record for each est, I get the latest record for each StatCode as shown here:

What am I missing?

posxf.png (10.5 kB)
sbi4s.png (5.5 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers