Date trouble

Question

How do I turn this:  2017-01-15

into:                       01/15/2017

Thanks.

Kenda · Accepted Answer

Use the DateTime tool (in the parse category).

Kenda · Accepted Answer

You could also use a normal Formula tool if you preferred. You would create a new string field with the following expression:

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

Either way works! Here is a page that gives you information on Alteryx Date/Time functions.