Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

changing the format of the dates

Ekta
8 - Asteroid

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

 

3 REPLIES 3
messi007
15 - Aurora
15 - Aurora

@Ekta,

 

Please see below how you can do it :

 

messi007_0-1636361980870.png

 

Attached the workflow.

Regards

JoeHerbert
Alteryx Alumni (Retired)

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
8 - Asteroid

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

Labels