I needed to simulate a Boolean value for use in a List Filter view, and used this calculated attribute to get the value:
Min(Max(DateDiff(target_resolve_date,Now(),"Day"),0,1)
A return value of 1 indicates that the target resolve date is prior to the present date, and a return value of 0 indicates that the target resolve date is later than the present date.
Rob.Ensinger wrote:
Hi Nock. Try DateDiff(target_resolve_date,Now(),"Day")