Trying to debug string to date format %m/%d/%Y

[pvara]

my Invoice Date is string and looks like 9/30/2019

How can i force it to be formatted as 9/30/2019? I used "%m/%d/%Y"

Is there something I am missing?

[AbhilashR]

Hi @pvara, Alteryx's native date format is yyyy-mm-dd which is why you are not able to get the string in mm/dd/yyyy format and give it a Date datatype. The screenshot below is from Alteryx's online help page:

https://help.alteryx.com/10.1/Reference/DateTimeFunctions.htm

[pvara]

Thank you. So how do you make it the format I am looking for?

[AbhilashR]

The date format you are looking to output will have to be in String datatype, which it is already in your case. 

[kelsey_kincaid · Accepted solution]

Hi @pvara , you can use the DateTime tool to convert the date to a string in the format of your choice, or you can create a new field with a string datatype and use the same DateFormat formula you already tried.