changing the format of the dates

Hello,

My data is something like this-

Field 1

NA

NA

NA

2017-12-12

2017-12-12

2017-12-12

I would like to convert the dates from yyyy-mm-dd to dd/mm/yyyy format keeping NA as it is so my desired output is -

Field 1

NA

NA

NA

12/12/2017

12/12/2017

12/12/2017

Many thanks in advance

Date Time

Common Use Cases

Accepted answers

Please see below how you can do it :

Attached the workflow.

Regards

Date_20211108.yxmd

All comments

Please see below how you can do it :

Attached the workflow.

Regards

Date_20211108.yxmd

you can do this in a number of ways, I've used 1 formula tool with an If statement to identify the 'NA' and then a DateTimeFormat to bring back the Date in the format required, you can find more out about the DateTime Data types here: https://help.alteryx.com/20213/designer/datetime-functions

Please mark as solution accepted when you are happy,

happy solving,

Joe

Datetimeparse.yxmd

@messi007 Thank you so much for formula, works perfectly fine.

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15878

MarqueeCrew 13708

apathetichell 13703