AnsweredAssumed Answered

Conditonal text on layout between two dates

Question asked by RandyRisser on Jun 25, 2012
Latest reply on Jun 25, 2012 by RandyRisser


Conditonal text on layout between two dates


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!