Calculate Due Dates
Calculate Due Dates

An easy way to set notifications related to due dates

An easy way to set notifications related to due dates

This template is based on the solution I provided in the community.

⁠

Loading community.coda.io⁠

⁠

Below you see the table I showed and the related code.

Base Table

Base Table

Name

Date

Type

IntervalMonth

step05

Next LP date: 11/11/2024

11/11/2022

11/11/2024

Next LCC date: not applicaple

10/8/2022

LCC

Next Corp date: 8/15/2024

8/15/2022

Corp

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.

Calculate Due DatesCalculate Due Dates