Date Range question

[Brad1]

I've got year or so worth of data that has a Date field.

I want use the earliest date and grab everything within 90 days of that date.  Then I want to grab the second earliest date and grab all records within 90 days of that date and so on.

I've pulled this out into a second table

Start Date     End Date      Date Range

2021-12-16 | 2022-03-16 | 2021-12-16 to 2022-03-16
2021-12-17 | 2022-03-17 | 2021-12-17 to 2022-03-17
2021-12-18 | 2022-03-18 | 2021-12-18 to 2022-03-18   ...and so on. 

So I have it to work with as well - if I need it.  What's the simplest/fastest way to go about this?  Thanks in advance for any help.

[phottovy · Accepted solution]

Hi @Brad1,

If I am understanding the questions correctly, you can use the generate rows tool and a join to accomplish this. I have attached an example workflow.

[binuacs · Accepted solution]

@Brad1 one way of doing this