Skip to main content

Hello, I am setting a legal case tracking base and I am trying to do something where:

1: When I input the date of incident, it automatically calculates two years from that date

2: I would like to have a table that also has a countdown until we reach the Statute of Limitations. 

Ideally, it would look something like: Date of Incident (03-11-24), Statute of Limitations (03-11-2026), Days remaining: 365

I attempted the Datetime_Diff between the two, but it just gives me the number of days between the Date of injury and SOL, so I think I can omit the Date of Injury and just have a running countdown so that every day when I log in, the day is one less remaining in the column that is counting down. 

To add two years to a date 

DATEADD({Date of Incident}, 2, "years")

To nest that inside the DATETIME_DIFF

 

DATETIME_DIFF(
DATEADD({Date of Incident}, 2, "years"),
TODAY(),
"days"
)

 

Note that you will get a negative number once two years have elapsed.

Reply


Terms & Conditions