Date Time Format

[AustinBauer]

Hi, I need to change my date format from YYYY-MM-DD to M/D/YYYY. Therefore, If it is day 1 of January I want it to show 9/1/2018 and not 09/01/2018. I do not want any leading 0's on the month and day. I have tried using the date-time tool but it does not seem able to filter dates in this way. Any ideas? If someone could make a sample workflow that would show me how to do this, it would be greatly appreciated. Thank you.

[jdunkerley79 · Accepted solution]

Try a formula tool with the expression:

Regex_replace(DateTimeFormat([Date],"%m/%d/%Y"),"\b0","")