Converting date format

[sebastiank88]

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

[alexnajm]

DateTimeFormat is best! DateTime Functions

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

[sebastiank88]

It will changed all values?

[alexnajm · Accepted solution]

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!

[davidskaife · Accepted solution]

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!

[sebastiank88]

Great, thank you very much! :)