Skip to content
Gallery
Notifications On Due Dates
Set Notifications
Calculate Due Dates
Dynamic Scheduling
More
Share
Explore

icon picker
Calculate Due Dates

An easy way to set notifications related to due dates
This template is based on the solution I provided in the community.

⁠
Calculate due date based on corporate entity law
@Christiaan_Huizer Thank you for the speedy reply. It’s cool that the community is so active! I will try these steps… I think I need to learn. little more about the “CurrentValue” to understand if this will work but this gave me something to start with! Thank you.
community.coda.io
⁠
⁠

Below you see the table I showed and the related code.
Base Table
Name
Date
Type
IntervalMonth
step05
1
Next LP date: 11/11/2024
11/11/2022
LP
24
11/11/2024
2
Next LCC date: not applicaple
10/8/2022
LCC
0
3
Next Corp date: 8/15/2024
8/15/2022
Corp
12
8/15/2024
There are no rows in this table
⁠
Sequence(1,20).ForEach(Product(CurrentValue,thisRow.IntervalMonth).WithName(intervals,
intervals.ForEach(

Date(
thisRow.Date.Year(),
thisRow.Date.Month() + CurrentValue,
thisRow.Date.Day()))
) - ToDay()).WithName(outcome,
Today() + outcome.Filter(CurrentValue > 1).First()).IfBlank("")


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.