Forum Discussion
- LauraThackerQrew CaptainToday() - [Date Modified]
- QuickBaseCoachDQrew CaptainDid you try my formula as a Formula numeric field type?
- QuickBaseCoachDQrew CaptainIf you want a numeric field for the # of days , it would be
ToDays(Today() - ToDate([Date Modified])) - KurtKelseyQrew 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.
- KatrinaEQrew CadetI'm trying to get the difference between todays date and the expected start date of a project but if the project has been started already, I want the value to be NA. I have a text field and it's not letting me put the "-", if I do a numeric, it won't let me do the value NA
If(
not IsNull([Started]),"N/A",
ToText(([Start])-(Now())
)
)- QuickBaseCoachDQrew CaptainTry this
If(
not IsNull([Started]),"N/A",
ToText(ToDays(Today() - [Start]))) - KatrinaEQrew CadetI'm getting an error, "-" can't be applied to dates and times
- QuickBaseCoachDQrew CaptainCan you tell me what type of field [Start] is?