How to convert supplier dates to the required format

The supplier can send dates as 12/31/2025, 2025-12-31, 12/31/25 or by text. The recipient often wants one strict format.

When to use

Settings are needed for promotions, expiration dates, renewal dates, price periods and schedules.

How to set up

1. Determine the date format in the source.
2. Select the date conversion action.
3. Specify the format you want as a result.
4. Check dates with single and double digit day/month.
5. Test on an empty or incorrect date.

What will happen

As a result, all dates will be written in one format that is understandable to the receiving system.

What is important to remember

• If the year is written in two digits, check how it is interpreted.
• It is better not to replace empty dates with today's date without an explicit rule.