Remove year from yyyy-mm-dd

Question

Hey,

I have a column with yyyy-mm-dd (Name) format rows.

Example: 2022-11-20 Alteryx Developer

I need to change it to 20/11 Alteryx Developer

i.e. dd/mm (Name)

Any idea how to do?

Felipe_Ribeir0 · Accepted Answer

Hi @ShantanuDagar

You can use this formula:

datetimeformat([Name], "%d/%m")

davidskaife · Accepted Answer

Hi @ShantanuDagar

Here is one way of doing it:

Use a Text to Columns tool to split into two columns on a space:

Then a Formula tool to perform the required changes and stitch the data back together:

binu_acs · Accepted Answer

@ShantanuDagar One way of doing this

ShankerV · Accepted Answer

hi @ShantanuDagar

One way of doing this,

Regex:  (.{10})(\s.+)

Formula: datetimeformat([RegExOut1],"%d/%m")+[RegExOut2]

Many thanks

Shanker V