If that is still hapening now, when you refresh that query in Desktop, only one thing left to try, turn your Date table function query into a table query - so you can see the value for the variable Today
Steps illustrating that process can be found here.