I’m attempting to use automation for the first time.
I’m setting 2 variables (which happen to be dates). Var 1 is today’s date, var 2 is the max date from a table. After these are set, I compare them. If they are equal, execute a script, if they aren’t equal, then pause the script.
My problem is that I can’t seem to get the comparison to work. I’m getting an error that says “variable value is not valid 1/3/2012 12:00:00 AM = 0”. The “1/3/2012 12:00:00 AM” is my “today” variable. For the “0”, I’m assuming is the max date I mentioned previously.
When the execute the SQL statement used to set the max date var, it correctly returns the value I’m expecting but it does not appear to be doing that when I use it in the automation script.
I’ve attached some images showing how I’m setting this variable. Am I doing it correctly? What am I missing?