# Date Driven Report

Options
✭✭✭✭✭✭
edited 12/01/20

Good afternoon,

We need to be able to create a report for our sheets that generates from the current date (todays date) and any date within 4 weeks after that.

We have a begin date and end date column. How can we create a report that only shows what will be happening in the next 4 weeks?

Thank you

• ✭✭✭✭✭✭
Options

Hi @BESP10

Hope you are fine, i created a sample sheet for your case and hope the following is answer your question:

1- add new Date type column called ( Check date ) calculate it's value using the following formula =TODAY() + 28 to define the date starting from today with 4 week in future.

2- add checkbox column (4 week Task filter) calculate it's value using the following formula =IF(OR(AND([begin date]@row > TODAY(), [begin date]@row < [Check date]@row), [end date]@row < [Check date]@row), true, false)

3- prepare report using filter to show task with checked value for the column ( 4 week Task filter ).

the following screen shot explain the solution :

bassam.khalil2009@gmail.com

• ✭✭✭✭✭✭
Options

Hi @BESP10

Hope you are fine, i created a sample sheet for your case and hope the following is answer your question:

1- add new Date type column called ( Check date ) calculate it's value using the following formula =TODAY() + 28 to define the date starting from today with 4 week in future.

2- add checkbox column (4 week Task filter) calculate it's value using the following formula =IF(OR(AND([begin date]@row > TODAY(), [begin date]@row < [Check date]@row), [end date]@row < [Check date]@row), true, false)

3- prepare report using filter to show task with checked value for the column ( 4 week Task filter ).

the following screen shot explain the solution :

bassam.khalil2009@gmail.com

• ✭✭✭✭✭✭
Options

Thank you @Bassam.M Khalil , I am almost there. I ran the report but dates are still showing up that are past the 28 days. We only want to see into the future for the next 4 weeks. What could I be doing wrong here?

• ✭✭✭✭✭✭
Options

Hi @BESP10

bassam.khalil2009@gmail.com

Options

Hi @BESP10

Our Reports recently had an update which have adjusted the way that the builder looks/works. Were you able to figure out how to set the dates?

In the new Report builder, you would select the Date Column to use as a filter, and set it to be In the Next (number) Days: