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!