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:
Drawer No #34 - 12/15/2017 - 1/11/2018
Drawer No #34 - 1/10/2018 - 1/31/2018
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