Skip to Content

How to Handle Multiple Date formats at once in SAP PI/PO?

Jan 02 at 03:03 PM


avatar image


I have a requirement where i get different DATE FORMATS from Source and i need to transform them into Desired Formate.

Case:We are picking files from Multiple Directory's Each file has different DATE Formate



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Muni M Jan 03 at 01:06 PM

are you using mapping and is the same mapping used for all ?

can you give us possible sender date format values and expected output date format?

Show 1 Share
10 |10000 characters needed characters left characters exceeded


Yes im using same mapping we have three date formates coming from Source 1. 2.dd/mm/yyyy 3.dd-mm-yyyy .

Expected output formate:dd-mm-yy,dd/mm/yyyy


Moritz Feuerbach Jan 05 at 01:20 PM

You'll need some kind of qualifier or so to differentiate between the different time/date formats. Otherwise this is an impossible task:

Image the following date format: 05012018. It may be 5th of January 2018, but as well May 1st if it is in american date format. Common date formats are yyyymmdd, ddmmyyyy, yymmdd, ddmmyy, not to mention different separators that may be used.

Are you able to determine the date format based on the folder or file name? If yes, you could use this information in ASMA and UDF in the mapping.

10 |10000 characters needed characters left characters exceeded