trying to create a calculation for due dates : have created the calculation If ( due date < Get ( CurrentDate ); "LATE" ;"pendding" ) works great in the same calendar year . once cross over to 2019 reports status as late????
Can you check to see that the due date field is defined as a date field (not text)?
Also, make sure the calculation is set to be Unstored so the result is dynamic.
(not related to the original result issue)
Thank you so much the due date field was set to text. It works now!!!
Retrieving data ...