Help

Statute of limitations countdown

Topic Labels: Formulas
159 1
cancel
Showing results for 
Search instead for 
Did you mean: 
aliawill2024
4 - Data Explorer
4 - Data Explorer

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. 

1 Reply 1

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.