How to create a formula that auto-populates a numeric field, based on the number of days between a pre populated end date and today's date.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

For example, if the "End Date" field is input as 17/12/2015 I want to automatically populate the days elapsed since then. For example today (05/01/2016) would be "days out of funding" Field would populate 19 days and automatically update as the date moves forward.

Photo of Georgia

Georgia

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Steven

Steven

  • 0 Points
Create a Formula - Numeric field where the formula is

           ToDays(Today()-[End Date])

Haven't tested but that should work. If you want it to be blank when today is before the "End Date", you could do

           If(ToDays(Today()-[End Date])<=0, null, ToDays(Today()-[End Date]))
Photo of Georgia

Georgia

  • 0 Points
That's perfect, thank you!