Skip to main content
Question

Formula to show how long a project has been in progress

  • December 19, 2020
  • 0 replies
  • 142 views

I am looking for a formula that shows the number of days a project has been in progress by calculating the days from the "date created" to the current day. I have tried several formulas and keep getting syntax errors. 

thanks!  



------------------------------
sara keller
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+15
  • DonLarson
  • Registered
  • December 19, 2020

Sara,

You need a Formula Duration field that will calculate the length of time between two dates.

There is a built in function in Quick Base to tell you what date today is called

  • Today()

The built in Quick Base field Date Created is a Date/Time field and not a Date field so you have to do a conversion on it to get your Duration.

  • ToDate([Date Created])

Finally you have to tell Quick Base to give you an answer in Days and not seconds, years or some other magnitude.

  • ToDays(Duration)

Putting it all together your end result is this:

ToDays(Today()-ToDate([Date Created]))



------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------

Terms & ConditionsAccessibility statement