I need to create a days filter as user input with standard 1,3,7 as the option in the drop down. This filter should return all records created within 1 , 3, 7 days respectively as selected by user.Any suggestions on how to create the formula.I created a formula but its only taking for one day.
Input:
ID DATETIME
123 9/20/2019
324 9/15/2019
Solved! Go to Solution.
@dexter90 You didn't provide a lot of information, so I had to make two assumptions:
1. The reference date for the filter is today's date.
2. You only want to filter on one of the 1,3,7 days at a time.
I created a macro attached that may be a starting point for you. A macro or an app will be the only way to provide a dropdown for a user to select the specific number of days you want to filter by.
Good luck.