Forum Discussion

StephenStephen1's avatar
StephenStephen1
Qrew Member
11 years ago

How to use Most Recent Date in a Dynamic Filter

I am Using to Tables: Companies & Projects. I have created a relationship between the two Tables that allows me to look at the "most recent date" of a Project for a Company. I have a report tha...
Forms
Relationships
reports and charts
AndrewNelson's avatar
AndrewNelson
Qrew Cadet
8 years ago
I know it's been several years, but I had this exact problem and wanted to let future generations know of the easy solution.  

Just create a Formula-Date field, and set the formula to just equal the value of the Summary field.  It mirrors the value exactly, but can also be used as a dynamic filter for reports.