Change date format

[rawan20201]

I want to change the date format from 2020-1-1 to 1/1/2000. I tried using DateTime and Formula, Action tools, but the result only applied in the workflow. When I tried to run the application, the new format did not appear. The required result is that when the user opens the application and selects a date, the date column in the Excel file output appears in the format 1/1/2000.

[binuacs]

@rawan20201 I believe you're looking for an analytic app where the user can select any date, and that date should be in the format mm/dd/yyyy. If that's the case, the attached workflow should work.

[apathetichell]

@rawan20201 --- should should review how dates are formatted. A date is the 'yyyy-mm-dd' format. Done. That's it. Anything else is a string. If you can explain what you are trying to do---- that might help, but a full column of excel dates should be natively brought in as dates in Alteryx. If they are a mix of dates and string in excel ---> they will become strings in Alteryx. You can use various tools to reformat your data as you want but in the end --- a date is YYYY-MM-DD. that's it.