DDiff from a date field to current date/now
I used this formula to get days from creation to deactivation. DDiff([Days in Client Last Deactivated On],[Days in Client Creation Date]) What formula can I use to obtain days from creation to curr...
Forum Discussion
I've used a similar formula in the past. We actually used a CASE formula to alternate between two scenarios: measuring between an 'open' and 'closed' date, and then if there is no 'closed' date, then measuring between the 'open' date and the current date. It was useful enough that I "starred" it for future reference in our system 🙂
case
when [# of unique Days in Dispute Closed On]=0
then min(DDIFF(Now([Days in Dispute Opened On]),[Days in Dispute Opened On]))
else min(DDIFF([Days in Dispute Closed On],[Days in Dispute Opened On]))
end
Since it's only two conditions, you could probably do the same thing with a regular IF formula instead of CASE, but the CASE lets you add more conditions in the future if need be.
