Forum Discussion
LauraThacker
6 years agoQrew Captain
Today() - [Date Modified]
- QuickBaseCoachD6 years agoQrew CaptainDid you try my formula as a Formula numeric field type?
- QuickBaseCoachD6 years agoQrew CaptainIf you want a numeric field for the # of days , it would be
ToDays(Today() - ToDate([Date Modified])) - KurtKelsey6 years agoQrew CadetHere is what I get:
The expression Today() on the left hand side of the operator "-" is of type datewhile the expression [Date Modified] on the right hand side is of type date/time. The operator "-" cannot be used with these types of expressions. - LauraThacker6 years agoQrew CaptainThis is because the [Date Modified] is a Date/Time field, and Today() is a "Date" value.
Mark's comment about displaying the number of days as a numeric value would be the formula to use:
ToDays(Today() - ToDate([Date Modified])) - KurtKelsey6 years agoQrew CadetWorked like a charm!!! Thank you kindly.