Countdown days until a specified date
So I have two fields: the first is a projected 'delivery date' and the second is a 'how many days until delivery" (essentially, its a countdown). On the Days-Until-Delivery field I have the following...
Forum Discussion
if you want a zero, this this will work
Max(ToDays([Projected Launch Date] - Today()),0)
That way it will never go below zero.
But if you want null (blank) then it would be
var number Countdown = ToDays([Projected Launch Date] - Today());
IF($Countdown >0, $Countdown)
Max(ToDays([Projected Launch Date] - Today()),0)
That way it will never go below zero.
But if you want null (blank) then it would be
var number Countdown = ToDays([Projected Launch Date] - Today());
IF($Countdown >0, $Countdown)
Thanks - I'm really glad that I asked, since my solutions were not even close to what you have there (and also why they weren't working!). I do like the idea of the null, so I appreciate that suggestion, as well.