After upgrading from Toad Data Point 3.2 (or older), to a newer version, some automation jobs are failing.
The If_Condition activity shows an error that "expression is not valid cannot be converted to boolean".
"Month()", "day()", and "now" are VB script and do not seem to be recognized as it did before.
Sample 1:
(month(now) = 1 and day(now) > 10) or (month(now) = 2 and day(now) <= 10)
Click the "Test" button and it does not evaluate and display as boolean. It just repeats, and displays at the same condition as a string.
Sample 2:
day(now) > 10
Click the "Test" button and this does not display as expected. "Now" should be the current date, and "day()" should return the day from that date. If the current date is greater then 10, than it should return "True".
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center