We will use a transformation that converts integers into dates: convert an integer into a date.
Step 1
If the column containing the SAB date is of type text, it must be converted to an integer.
Right-click on the relevant field in the field list (left panel). Choose change field type. Convert to integer. The relevant field becomes an integer type in the field list:
Step 2
In the list of transformations, in the group related to dates, choose the transformation convert an integer into a date.
Select the relevant column in the field list.
Select the Century Marker format in the list of date formats. Press the Apply button.
How to read SAB dates?
How to read SAB (Sopra Banking) dates?
Solution:
Step 1
If the column containing the SAB date is of type text, it must be converted to an integer.
Right-click on the relevant field in the field list (left panel). Choose change field type. Convert to integer. The relevant field becomes an integer type in the field list:
Step 2
In the list of transformations, in the group related to dates, choose the transformation convert an integer into a date.
Select the relevant column in the field list.
Select the Century Marker format in the list of date formats. Press the Apply button.