The date format set in SAP environment may differ with the date format set on the system. So when any date field is retrieved from SAP to DS, the date format retrieved is different when compared to system date format. The dynamic formula therefore allows users to change the date retrieved from SAP into the system date format at run time.
For example we have a date format (DD.MM.YYYY) as below in SAP and the system date format as (MM/DD/YYYY).
In Mapper, select the respective DF for the date field which is to be populated from SAP.
Run the process file and notice the date is same as the system date format.
Next: