aging based on invoice date

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • Answered
How do I create a formula that calculates how old an item is based on date (ex. aging based on invoice date or aging based on due date)

Current
1week old
2 weeks (etc)

Current
30 days
60 days (etc)
Photo of Carla

Carla

  • 150 Points 100 badge 2x thumb

Posted 9 months ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
If you create a "formula duration" field, you can then add a simple formula to subtract the difference between 2 dates.

If its a Date/Time field, like [Date Created] use:
Now()-[Date Created]

If it is a Date only field, use:
Today()-[Date]

or if you need to convert a Date/Time to just date, use:
Today()-ToDate([Date Created])

By default, formula duration fields use 'smart units'.  But you can change that to weeks or days as desired.



Matthew Neil - Product Specialist
(Edited)
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,570 Points 50k badge 2x thumb
Typically its a formula like this.

var number AGE = ToDays([Today()-[Invoice Date]);

IF(
[AGE] < 30, "Current",
[AGE] < 60, "30+",
[AGE] < 90, "60+", "90+")