AnsweredAssumed Answered

Find the most recent date of a group within next 7 days

Question asked by spudmw on Jan 8, 2018
Latest reply on Jan 9, 2018 by spudmw

Hello all,

I have seen similar questions about this but can seem to find one that addresses my issue.  I want to find the most recent date of records grouped by drawer number but only if its within the next 7 days.  So for example:

 

John

Drawer No #34 - 12/15/2017 - 1/11/2018

Drawer No #34 - 1/10/2018 - 1/31/2018

 

Meg

Drawer No #23: 1/1/2018 - 1/15/2018

 

Only Meg would show up as the record to use, omitting John completely.   Right now I am using sort and it gives me the max dates for each records but as you know it doesn't work with finds and I cant figure out for the love of me how to get just that record.  Last and Max does not work either.

 

Thanks in advance

Outcomes