Forum Discussion
Laura_Thacker
7 years agoQrew Commander
Today() - [Date Modified]
- QuickBaseCoachD7 years agoQrew CaptainDid you try my formula as a Formula numeric field type?
- QuickBaseCoachD7 years agoQrew CaptainIf you want a numeric field for the # of days , it would be
ToDays(Today() - ToDate([Date Modified])) - KurtKelsey7 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. - Laura_Thacker7 years agoQrew CommanderThis 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])) - KurtKelsey7 years agoQrew CadetWorked like a charm!!! Thank you kindly.