Is there a way to specify a date (2020-01-20) and then return every 2 weeks forward and backwards between a start and finish period. So 01 Jan 2020 to 01 Mar 2020 for example. A list of of all the dates every 2 weeks from this input date.

Sample of table data for reference...

```
DECLARE @Source TABLE(bookingcode int, NextWeekCommDate DATETIME, Cycle int)
insert into @Source (bookingcode, NextWeekCommDate, cycle)
select 556789, '23 Mar 2020', 2
insert into @Source (bookingcode, NextWeekCommDate, cycle)
select 556790, '30 Mar 2020', 3
select * from @Source

declare @from datetime = '01 Mar 2020'
declare @to datetime = '01 Jun 2020'

```

Then I am trying to output the following results based on the declared@to and @from dates

```
bookingcode     CycleOccurDate
556789          2020-03-09 00:00:00.000
556789          2020-03-23 00:00:00.000
556789          2020-04-06 00:00:00.000
556789          2020-04-20 00:00:00.000
556789          2020-05-04 00:00:00.000
556789          2020-05-18 00:00:00.000
556790          2020-03-30 00:00:00.000
556790          2020-04-20 00:00:00.000
556790          2020-05-11 00:00:00.000

```

So it works backwards as well from the NextWeekCommDate if the @from date is before this Thank you again