Display next closest Mon - Sunday period's due items

brendan.a.ford · 2023-08-23T02:54:32.216Z

I’m trying to show items that are due next week, where next week is the next closest Monday - Sun period.

I’ve tried a couple expressions but no luck and I can’t figure out how to configure the Mon - Sun period within the expression…
What expression should I be using?

Screenshot 2023-08-23 at 2.51.52 PM668×508 20.7 KB

mikeloc · 2023-08-23T11:42:20.927Z

Hi there, @brendan.a.ford… give these constraints a go… I think they should do the trick.

constraints890×568 39.2 KB

Hope this helps.

Best…
Mike

brendan.a.ford · 2023-08-23T21:30:17.973Z

Fantastic - it worked perfectly. Do you mind just breaking down and explaining the “:rounded down to week +(days): N” expression for me so I can understand it better?

Thanks @mikeloc!

mikeloc · 2023-08-23T21:34:45.225Z

Rounding the current date/time down to week gives you the very start of the current week (i.e., 12:00am on the Sunday that starts the week). Add 8 days to the current date/time rounded down to week and you get the Monday of the following week. Add 14 days to it and you get the Sunday that follows the Monday you just got.

brendan.a.ford · 2023-08-23T21:37:21.184Z

Awesome explanation, makes perfect sense. Thanks again!

mikeloc · 2023-08-23T21:41:19.249Z

Actually, now that I look at it again, you should add 15 days to the second constraint so that the Sunday is included (the way it is now, it would cut off at 12:00am on the Sunday).

brendan.a.ford · 2023-08-23T21:43:49.278Z

Good catch! Updated.

Thanks

brendan.a.ford · 2023-08-24T00:33:12.672Z

@mikeloc when I try to apply this logic to another time period (ie: Tomorrow) there seems to be an issue as nothing appears in the RG for Tomorrow, even though I’m filtering correctly (I believe).

Screenshot 2023-08-24 at 12.30.38 PM1410×890 92.3 KB

There wouldn’t be a discrepancy between the date/time picker plugin I’m using for the ‘duedate’ field and my actual browser date/time would there?

mikeloc · 2023-08-24T00:38:01.874Z

The current date/time plus 1 day is an exact moment tomorrow, and it is very unlikely that a task is due at that exact moment (which is why nothing is appearing in the repeating group). You need to use two constraints like I showed you, and round down to date instead of week.

brendan.a.ford · 2023-08-24T00:41:02.882Z

I see - so “rounded down to X” essentially starts the logic from X, rather from ‘this point in time’?

brendan.a.ford · 2023-08-24T00:44:49.739Z

Screenshot 2023-08-24 at 12.43.42 PM1386×904 102 KB

Appears to have worked perfectly! It’s apparent to me now that an ‘end constraint’ must also be applied in order to capture data within a date range - obviously.

Thanks @mikeloc - super helpful!

system · 2023-11-01T02:54:46.311Z

This topic was automatically closed after 70 days. New replies are no longer allowed.