Date/Time Parse

[JeffJones]

I have a date in the format of 2023-02-23.  I am having trouble getting it to convert to a format of 2/23/2023.

I performed a date/time function to get the data to 2023-02-23  as shown below but can get it to end up as 2/23/2023

[BrandonB · Accepted solution]

If you are starting with an actual date data type you can use DateTimeFormat([DateField], "%m/%d/%Y") to get it into your desired format in a formula tool. 

https://help.alteryx.com/20223/designer/datetime-functions use this link as a reference page for date type operators