Producing a Date Filter as a Report option
Date Filters are created from the Report Options page to create a Date range
Date filters create filters for the Start date and End date based on the user’s input.
How to create a Date Filter using Report Options
Open your excel report and go to the Jet tab.
Navigate to Tools and click on the Report Options function.
On the drop-down, you should have a pop-up as shown below.
we then fill in as shown below
Fill in the first space with 'Start Date'
Fill in the first space with 'End Date
Also, fill in your required date under Value,
Then click on ok.
Once you click on ok, it will automatically create a new sheet titled Options. You do not need to run this, it should look something like this.