AnsweredAssumed Answered

Comparing todays date with another

Question asked by CliveWolstencroft on Feb 9, 2013
Latest reply on Mar 3, 2013 by hbrendel

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

Outcomes