Skip to content
dynamic planning
Share
Explore
DB Intervals

icon picker
Testing intervals

Showing the impossible match between weekday and month interval
What is a good choice when it comes to an each month alike approach?
the first date
the last date
the nearest date as you find in column ‘nearby’?

Testing intervals
0
Name
testdate
repeat
nextDate
two options
nearby
1
StartDate: Sun, Jan 8, 2023, Repeats each day and has as next date → Mon, Jan 9, 2023
1/8/2023
Repeats each day
Mon, Jan 9, 2023
2
StartDate: Sun, Jan 8, 2023, Repeats each 2 days and has as next date → Tue, Jan 10, 2023
1/8/2023
Repeats each 2 days
Tue, Jan 10, 2023
3
StartDate: Sun, Jan 8, 2023, Repeats each 3 days and has as next date → Wed, Jan 11, 2023
1/8/2023
Repeats each 3 days
Wed, Jan 11, 2023
4
StartDate: Sun, Jan 8, 2023, Repeats each 6 weeks and has as next date → Sun, Feb 19, 2023
1/8/2023
Repeats each 6 weeks
Sun, Feb 19, 2023
5
StartDate: Sun, Jan 8, 2023, Repeats each 7 weeks and has as next date → Sun, Feb 26, 2023
1/8/2023
Repeats each 7 weeks
Sun, Feb 26, 2023
6
StartDate: Sun, Jan 8, 2023, Repeats each 8 weeks and has as next date → Sun, Mar 5, 2023
1/8/2023
Repeats each 8 weeks
Sun, Mar 5, 2023
7
StartDate: Sun, Jan 8, 2023, Repeats each 9 weeks and has as next date → Sun, Mar 12, 2023
1/8/2023
Repeats each 9 weeks
Sun, Mar 12, 2023
8
StartDate: Sun, Jan 8, 2023, Repeats each month and has as next date → Wed, Feb 8, 2023
1/8/2023
Repeats each month
Wed, Feb 8, 2023
Sun, Feb 12, 2023Sun, Feb 5, 2023
Sun, Feb 5, 2023
9
StartDate: Sun, Jan 8, 2023, Repeats each 2 months and has as next date → Wed, Mar 8, 2023
1/8/2023
Repeats each 2 months
Wed, Mar 8, 2023
Sun, Mar 12, 2023Sun, Mar 5, 2023
Sun, Mar 5, 2023
10
StartDate: Sun, Jan 8, 2023, Repeats each 3 months and has as next date → Sat, Apr 8, 2023
1/8/2023
Repeats each 3 months
Sat, Apr 8, 2023
Sun, Apr 9, 2023Sun, Apr 2, 2023
Sun, Apr 9, 2023
11
StartDate: Sun, Jan 8, 2023, Repeats each 4 months and has as next date → Mon, May 8, 2023
1/8/2023
Repeats each 4 months
Mon, May 8, 2023
Sun, May 14, 2023Sun, May 7, 2023
Sun, May 7, 2023
12
StartDate: Sun, Jan 8, 2023, Repeats each 5 months and has as next date → Thu, Jun 8, 2023
1/8/2023
Repeats each 5 months
Thu, Jun 8, 2023
Sun, Jun 11, 2023Sun, Jun 4, 2023
Sun, Jun 11, 2023
13
StartDate: Wed, Mar 8, 2023, Repeats each 6 months and has as next date → Fri, Sep 8, 2023
3/8/2023
Repeats each 6 months
Fri, Sep 8, 2023
Wed, Sep 13, 2023Wed, Sep 6, 2023
Wed, Sep 6, 2023
14
StartDate: Sun, Jan 8, 2023, Repeats each year and has as next date → Mon, Jan 8, 2024
1/8/2023
Repeats each year
Mon, Jan 8, 2024
Sun, Jan 14, 2024Sun, Jan 7, 2024
Sun, Jan 7, 2024
15
StartDate: Sun, Jan 8, 2023, Repeats each 2 years and has as next date → Wed, Jan 8, 2025
1/8/2023
Repeats each 2 years
Wed, Jan 8, 2025
Sun, Jan 12, 2025Sun, Jan 5, 2025
Sun, Jan 5, 2025
16
StartDate: Wed, Mar 8, 2023, Repeats each 10 years and has as next date → Tue, Mar 8, 2033
3/8/2023
Repeats each 10 years
Tue, Mar 8, 2033
Wed, Mar 9, 2033Wed, Mar 2, 2033
Wed, Mar 9, 2033
There are no rows in this table

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.