4 Replies Latest reply on Mar 3, 2013 2:44 PM by hbrendel

    Comparing todays date with another

    CliveWolstencroft

      Title

      Comparing todays date with another

      Post

           I am trying to show if a policy expiry date (cover_to_date) is after Today, the policy has lapsed.

            If ( Cover_To_Date>Get(CurrentDate); "Lapsed" ; "In-Force" )

           Can anyone please explain to me why this formula is not working and what I need to do to fix it!

            

           Many thanks

            

           Clive