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)
Greetings,
This post is the one I found would be most relevant.
I have a report containing fields [QName], [Overall End], and {Next Val Date] which is a report formula (Formula - Date) containing ToDate([Overall End]) + Days(90). This performs exactly as needed..
I tried adding a filter that would only show the records that were within 5 days of [Next Val Date] however, the criteria is a text field rather than allowing me to select a date 5 days before [Next Val Date].
I found this post and tried both suggestions but I don't have [Next Val date] to select from in the fields drop-down.
I used {Formula - Date/Date/Time/Numeric/Duration] but none showed [next Val Date] in the fields list.
What am I missing here??
------------------------------
Rene Jamis
------------------------------