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?
Solved! Go to Solution.
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
Thank you. So how do you make it the format I am looking for?
The date format you are looking to output will have to be in String datatype, which it is already in your case.
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.