Date format in EDIFACT UNB Header

Question

I am creating an Outbound EDIFACT Orders using a Logic App. I have successfully created the EDIFACT File, however the The Date in the UNB Header is generated in an 8 Character format (YYYYMMDD). I need this date to be in a 6 character format YYMMDD as defined in the standards. https://www.gs1.org/sites/default/files/docs/eancom/ean02s3/part2/orders/052.htm

I am unable to see anywhere that allows me to specify the format of the Date field. What's the best way to Correct the date on the message Header in an edifact file?

UNA:+.?*'
UNB+UNOA:3+SENDER:ZZ+RECIEVER:ZZ+20240403:0258+70'
UNH+82+ORDERS:D:01B:UN:EAN007'
BGM+220+PO-1010-000611+9'
DTM+137:202401231200:203'

Answer 1

Hi @Anonymous ,

There are several ways to format the date in Logic apps.
It can be done by using functions like formatDateTime or convertTimeZone.

But on stackoverflow (https://stackoverflow.com/questions/46463997/how-to-set-date-time-format-in-logic-app) I found a workaround with the convert time zone task:

Kind Regards,

Wilko

---

Please do not forget to "Accept the answer” wherever the information provided helps you, this can be beneficial to other community members. If you have extra questions about this answer, please click "Comment".