Something odd has started to happen with one of my weekly reports with the variables:
StartDate (SELECT TO_CHAR(SYSDATE-7,‘MMDDYY’) FROM DUAL)
EndDate (SELECT TO_CHAR(SYSDATE-1,‘MMDDYY’) FROM DUAL)
Previously (and in the Variable testing, no less) these would return dates of 7 days ago and 1 day ago respectively. Pretty easy, right?
Starting about one week ago, both variables started returning the same value - the equivalent of “EndDate”.
I’ve double- and triple-checked my automation script to make sure someone didn’t accidentally replace #StartDate# with #EndDate# - everything is as it should be. In fact, the script hasn’t been modified since I built it.
Are StartDate and EndDate reserved words that suddenly caused a problem? Like I said, up until about a week ago everything generated exactly as I expected it to.
I know I can just go in and change the name of the variables - I’m just concerned that it suddenly stopped working without any changes to the script.