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

[JCornn]

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.

[AngelosPachis · Accepted solution]

Hi @JCornn ,

In a formula tool, try the following expression

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

[DawnDuong]

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]

@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]

This works perfectly! Thank you!