If(Get(CurrentDate)>Type of Grant::Due;"YES";"NO")
Check do not store - Recalculate as needed.
You could use your Today variable, but it would need to be unstore also.
It looks like you reversed your if statement above.
My if statement will display yes if the current date is past the due date and no if it is not passed the due date.
Use your first calculation, but put it in a field of type calculation and click the storage options so that you can make this an unstored calcualtion. It will then update correctly with each new day.
Thank you for both suggestions. Based on these, it works.