Login / Sign up
Table transformations

How to format a date as YYYY-MM-DD

2026-06-20
Task

The source table has a date written as 24.06.2026, while the receiver needs YYYY-MM-DD.

Short Answer

In the date column, add a Convert date transformation and choose DD.MM.YYYY → YYYY-MM-DD.

How to Do It in Eofferix

  1. In the table editor, open the settings of the available_from column.
    Opening the available_from column settings in the Eofferix table editor
    The settings button is highlighted under the available_from column.
  2. In Transformations, add a rule: condition Current value — Any, action Convert date, format DD.MM.YYYY → YYYY-MM-DD.
    Rule that converts a date to YYYY-MM-DD
    In available_from settings, the date conversion from DD.MM.YYYY to YYYY-MM-DD is selected.
  3. Save the column settings.

Before / After

Before

source data
skuavailable_from
SKU-100124.06.2026

After

result
skuavailable_from
SKU-10012026-06-24

Process data faster with Eofferix

Create a free account to automate catalogs and price lists around your own rules.

Sign up