Forum Discussion
chudson002
Jan 02, 2022Brass Contributor
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