Remove year from yyyy-mm-dd

[ShantanuDagar]

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 solution]

Hi @ShantanuDagar 

You can use this formula:

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

[davidskaife · Accepted solution]

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:

[binuacs · Accepted solution]

@ShantanuDagar One way of doing this

[ShankerV · Accepted solution]

hi @ShantanuDagar 

One way of doing this, 

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

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

Many thanks

Shanker V

[ShantanuDagar]

Perfect guys for quick solutions, all works but using @davidskaife method. 

[EN6924]