DATEDIFF DILEMMA

Contributor

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))))

chudson002_1-1641088054783.png

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)))

chudson002_2-1641089447947.png

Thanks in advance for assistance.

 

V/R

chudson002

0 Replies