Trying to set up filters on a request report that only returns request greater than 30 days old based on the Submission Date. I’d like to do this dynamically but can only see an option to manually set a date 30 days ago every time I run the report. Any help on dropdowns or custom syntax to use so it automatically returns request greater than 30 days old would be great. Thank you.
.
Hi
A Formula Field can help you here!
From the field picker (in the filters, or column selector), click on Add formula column
Use the DateDiff function to find the difference between two dates (as a number) in a specified unit. In this case, we want the difference between the Submission Date and the current Date in n umber of days:
DateDiff(Now(),$SubmissionDate,'d')
Then use this formula field in your filter:
Test this out and let us know how you get on!
Pete
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.