Date conversion to not include 0 in 12/01/2017

[jark1294]

I'm trying to change a date to format MM/DD/YYYY, but need to keep it as a vw string so i can use it in a lookup later. The input data has a date as 12/01/2017, for example, and i want it to just be 12/1/2017. Or vice versa for the other data set. I'm used this formula but it isn't getting rid of the 0

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

[JohnJPS · Accepted solution]

Would something like this work:

TrimLeft(Replace(DateTimeFormat([Date],"%m/%d/%Y"),"/0","/"),"0")

This trims the leading zero if there is one, and also the middle zero if there is one.

Hope that helps!

John

[jark1294]

Thank you! I actually thought of the same thing while i was waiting for a response, but figured alteryx community would come with something. This is perfect, appreciate it!