I'm trying to create a formula that shows how many dats are left until a case will close. In my instance, a case closes in 5 days after our field labeled "Last Modified Date." I don't have any kind of "expires by/on" date field to work with. Is there a way to do "Last Modified Date" PLUS 5 Days, then return the number of days between that date and the last modified by date?
17 réponses
That tells me that LAST_UPDATEONLY is a DateTime field, not a Date, so you need to use either
( DATEVALUE( LAST_UPDATEONLY) + 5) - TODAY()
or
( LAST_UPDATEONLY + 5) - NOW()
