Alteryx Designer Desktop Discussions

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

Converting Date / Time field

jregaNYC
5 - Atom

I have a Date Time field that has the format: YYYY-MM-DD HH:MM:SS

 

I'd like to change the format to: MM/DD//YYYY but I'm not sure if the best approach is to use a tool or a formula. 

 

Any assistance would be appreciated.

 

Thanks,

Jenifer

3 REPLIES 3
gautiergodard
13 - Pulsar

hey @jregaNYC 

here is one way to do it with the data time tool

Qiu
21 - Polaris
21 - Polaris

@jregaNYC 
We can also use the DateTimeFormat function in Formula tool.

0420-jregaNYC.PNG

Raj
16 - Nebula

using the formula tool is an easy way of implementing it.

Labels