changing the format of the dates

[Ekta]

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

[messi007 · Accepted solution]

@Ekta,

Please see below how you can do it :

Attached the workflow.

Regards

[JoeHerbert]

Hi @Ekta 

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 

[Ekta]

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