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.
