Forum Discussion

StephenStephen1's avatar
StephenStephen1
Qrew Member
10 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
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. 
AaronZielinski's avatar
AaronZielinski
Qrew Cadet
7 years ago
Andrew, I filter by date (shown below), but would love to be able to have the current date be the beginning date.  However, I don't want to hard code it in though where I can't select a date that is before the current date.  Do you know if your solution above can do this or any other way to achieve this goal?  Thanks!