Discussions

 View Only
  • 1.  Formula to show how long a project has been in progress

    Posted 12-18-2020 23:04

    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
    ------------------------------


  • 2.  RE: Formula to show how long a project has been in progress

    Posted 12-19-2020 08:26

    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
    ------------------------------



  • 3.  RE: Formula to show how long a project has been in progress

    Posted 12-19-2020 15:50

    That worked! Thank you so much! I am not sure what I was doing wrong before, but I am thankful for this community. 



    ------------------------------
    sara keller
    ------------------------------