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
Solved! Go to Solution.
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
@messi007 Thank you so much for formula, works perfectly fine.