4 Replies Latest reply on Jun 25, 2012 12:05 PM by RandyRisser

    Conditonal text on layout between two dates

    RandyRisser

      Title

      Conditonal text on layout between two dates

      Post

      Hello I have two dates. Last issue date and Gift last issue.

      I have a layout that I would like to have the word Expired to show on that record via a condition.

      If Last issue date or Gift last issue date is less then today's date. Show the word Expired on the layout.

      I tried this "Fishwrapper::Last issue or Fishwrapper::Gift Last Issue < Get(CurrentDate)" and it worked except there are random records that it just doesn't work. It's not always correct. Most the time it is but not always. I think the problem is because one of them is always blank.

      If last issue has a date in gift last issue does not or if gift last issue has a date filled in the last issue does not.  I'm not sure if that is what throws it off or not.

      What would be the best way to do this scenario?

      Thanks for the help!