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,
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
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.
Finally you have to tell Quick Base to give you an answer in Days and not seconds, years or some other magnitude.
Putting it all together your end result is this:
ToDays(Today()-ToDate([Date Created]))
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
That worked! Thank you so much! I am not sure what I was doing wrong before, but I am thankful for this community.
