Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
Free Trial

Alteryx Designer Desktop Discussions

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

Change V_String date format from YYYY-MM-DD to MM/DD/YYYY

JCornn
7 - Meteor

Hello,

 

I am looking for help figuring out a formula that can convert V_String date format from YYYY-MM-DD to MM/DD/YYYY while remaining V_String.

 

Thank you for the help.

4 REPLIES 4
AngelosPachis
16 - Nebula

Hi @JCornn ,

 

In a formula tool, try the following expression

 

Datetimeformat([Field1],"%m/%d/%Y")

 

AngelosPachis_0-1633468693469.png

 

DawnDuong
13 - Pulsar
13 - Pulsar

hi @JCornn 

The formula that @AngelosPachis mentioned is the most efficient. Do note that you need to set the datatype of the original YYYY-MM-DD field to "Date" or "Datetime" for this function to work. 

Check out more datetime formula here: https://help.alteryx.com/20213/designer/datetime-functions

Dawn

AngelosPachis
16 - Nebula

@DawnDuong I think that this formula is still going to work if the data type of the original Field is a string. 

 

I noticed that in the past as well, how Alteryx tends to recognise dates in a string data type as actual dates, so you may not get an error

JCornn
7 - Meteor

This works perfectly! Thank you!

Labels
Top Solution Authors