Calculating if an item is overdue based on comparison of dates
I am trying to generate a field in my FM12 Pro databes that would automatically generate a Yes or No entry depending if a grant is overdue based on a comparison of due date and today's date. In trying to do that I have specified the following option for a text field:
If (Type of Grant::DueDate_TypeGrants>Get(CurrentDate);"yes"; "no" )
but it doesn't work. Any suggestions are appreciated. I have also tried creating a "Today" field in the same database to generate the current date, i.e. Get(CurrentDate) and then using the following expression
If (Type of Grant::DueDate_TypeGrants>Today;"yes"; "no" )
which also doesn't work. Thanks.