Thanks all! I was trying to make this a macro that could run yearly, thus the “0725” instead of using the entire date.
It's kind of a silly experiment, but the whole story is, we have an old Mac Mini that does nothing but play music for our telephone hold system. I wanted to set it so it plays certain playlists during certain times of the year (e.g. Holiday music during the holidays).
The whole idea was to automate everything so no one would ever have to touch it. So I turned the Year into a variable.
Then I tried a few combinations of what @ccstone and @peternlewis suggested but still can't get it to work.
Here, I tried to incorporate a dateTest but it seems to act as an "OR" test than an "AND" test. That is, if Today is greater than the start date OR less than the end date, it's true. But I want it as an "AND".
Then I tried it as a direct calculation, but it keeps coming up false no matter what I set the start and end dates to.
Maybe I'm missing something?