Forum Discussion
chudson002
Nov 27, 2021Brass Contributor
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