3 Replies Latest reply on Nov 29, 2012 12:03 PM by IzetKapetanovic

    Calculating if an item is overdue based on comparison of dates

    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.