AnsweredAssumed Answered

Calculating if an item is overdue based on comparison of dates

Question asked by IzetKapetanovic on Nov 29, 2012
Latest reply on Nov 29, 2012 by IzetKapetanovic

Title

Calculating if an item is overdue based on comparison of dates

Post

     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.

      

Outcomes