Forum Discussion

MikeRorstad's avatar
MikeRorstad
Qrew Cadet
7 years ago

Duration between a date and a variable set to a contract start date

I set ContractStart as a Variable in Home/Settings/Variables.

I then want to calculate the number of days since the contract start date.

I set a field for [Date] and have tried all sorts of variations for my [Duration From Contract Start' field.

I tried making it a Formula - Duration
Days([Date]-ToDate([ContractStart])) yields "expecting number but found duration"

ToDays([Date]-ToDate([ContractStart])) yields "expecting duration but found number"

Changing the field to Formula - Number

ToDays([Date]-ToDate([ContractStart])) yields no error messages but nothing populates the field.

Errors
Formulas and functions
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    I can help you, but why would you want to set a global variable for the contract start.  Do you have a record representing each separate contract?  Does that Contract record have the Contract Start Date as a field and the other field you call [Date]?

    Or does the whole app really refer to a single date for the Contract Start Date.