How can I validate dates entered in an Excel Migration Job (IFS 9)?
I have a migration job where the user can modify a date, but if the user enters an invalid date (for exampel giving an invalid month) there is no error thrown (other errors work fine). The record status is “Updated” after execution, even though nothing has been updated.
Can to_date() be used? In that case, where should it be placed in the migration job to be executed?
Thanks!
