Forum Discussion

chudson002's avatar
chudson002
Brass Contributor
Jan 02, 2022

DATEDIFF DILEMMA

Happy New Year Community,

Need to calculate the number of days between Closed Out and Due

AND

calculate the number of days between Today and Due when Closed Out is Blank.

 

If(ThisItem.Timely = 0, (DateDiff(Today(), ThisItem.Due, DateDiff(Today(), ThisItem.Due))))

The code does not error out, but it does not return the number of days for each formula.

 

If(ThisItem.Timely = 0, (DateDiff(Today(), ThisItem.Due) Or DateDiff(Today(), ThisItem.Due)))

Thanks in advance for assistance.

 

V/R

chudson002

No RepliesBe the first to reply

Resources