8 Replies Latest reply on Sep 10, 2018 5:12 AM by Michael Gillespie

    Dynamic statements based on evaluation of a date

    Andy Hulsey

      I'm working on providing a countdown to a given date. So, with the help of a tip from Jonathan Drummey, I can do that, as in the attached workbook.


      The next step is to display different messages based on the relationship of today's date to the given date.


      If today() is before the [Target Date], then display the countdown, which I have been able to accomplish.


      If today() is the same as the [Target Date], I need to display the message, "Enrollment ends today" and then today's date.


      If today() is after the [Target Date], I need to display the message, "Enrollment ended on," and then the target date.


      I've tried a few variations of this in an if statement, but so far no luck.


      Has anyone solved a similar problem?