Skip to main content

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!

Hello,

I have the same issue. Did you find the solution for it please?

Select the cell where you want the data validation applied.

On the Ribbon, click the Data tab, then click Data Validation.

From the Allow drop down, select Date.

In the Data drop down, select one of the operators, such as Greater Than, or Between.

 

 

 

 

www.tellthebell.com
 

Reply


Terms & ConditionsCookie settings