Converting date format

Hello,

I have a multiple values in a cell (string format). I want to changed them to format which are in target data. Do you know which function will be the best to use? (regex?) if so can anyone of you provide me a solution?

I attached example file.

Kind Regards,

Sebastian

Book1.xlsx

Designer Cloud

Date Time

Accepted answers

alexnajm

Ah I see - I assumed they were separate cells. I would then separate them out with a Text to Columns on the pipe delimiter, convert them using a Formula or a Multi-Field Formula (same formula as above), and then Formula them back together!

Screenshot 2025-07-31 073439.png

davidskaife

Hi @sebastiank88

Here's a way of doing it:

Add in a Record ID tool, then a Text to Columns tool to parse on pipe and split into rows

A Data Cleansing tool to remove whitespace from the date column

Perform the conversion to the required format using a Formula tool and the DateTimeFormat expression as you're already in the standard date format

Summerize tool to group by Record ID, and concatenate the date Column, using a pipe as the separator

Finally sort in ascending order on Record ID

Workflow attached!

Date Conversion.yxmd

All comments

alexnajm

DateTimeFormat is best! DateTime Functions

DateTimeFormat([Data], "%d.%m.%Y")

sebastiank88

It will changed all values?

alexnajm

Screenshot 2025-07-31 073439.png

davidskaife

Hi @sebastiank88

Here's a way of doing it:

Add in a Record ID tool, then a Text to Columns tool to parse on pipe and split into rows

A Data Cleansing tool to remove whitespace from the date column

Perform the conversion to the required format using a Formula tool and the DateTimeFormat expression as you're already in the standard date format

Summerize tool to group by Record ID, and concatenate the date Column, using a pipe as the separator

Finally sort in ascending order on Record ID

Workflow attached!

Date Conversion.yxmd

sebastiank88

Great, thank you very much!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703