Forum Discussion

chudson002's avatar
chudson002
Brass Contributor
Nov 27, 2021

COMPARE DATES and RETURN Yes or No

Good Day Community,

Need for field Timely to result in "Y" or "N".  Using a Label to display Timely.

If Closed <= Due, Timely = Y and 

If Today > Due Date, Timely = N or

If DaysOverdue <1, Timely = N

 

       End              Due         Closed       Timely     Days Overdue

If(ThisItem.Closed <= ThisItem.Due, "Y" && Value(DaysOverdue.Text) < 1, "N", Blank())

There isn't an error on the syntax, but not getting the result of "Y" or "N"

 

When the below was tried, all the rows returned "Y". None were "N"

If(ThisItem.ClosedOut <= ThisItem.Due, "Y", "N")

 

Any assistance would be greatly appreciated.

No RepliesBe the first to reply

Resources