I have data from a database that shows the date format as MM-DD-YYYY HH:SS. I am not able to change this in the operating system. Is there a way to setup a formula in Alteryx to change the date format to be DD-MM-YYYY HH:SS? Sample date file attached.
Hi @ebowlan
Strangely i am getting below date format from your excel file
Here is how you can do it. Multi-field formula tool is really helpful when you want to apply formula on multiple columns. Refer below interactive lesson to learn more about its usage.
https://community.alteryx.com/t5/Interactive-Lessons/Multi-Field-Formulas/ta-p/424422
You can use DateTimePrase() function to convert non Alteryx date format to Alteryx date format (YYYY-MM-DD HH:MM:SS). Then use DateTimeFormat() to convert it into the required format. Refer the below page to understand more on its usage.
Workflow for your usecase would be like below
Hope this helps : )
Hi @ebowlan
You can use a datetimeparse function to convert the value to a standard Alteryx datetime format, which is YYYY-MM-DD HH:MM:SS and then use a datetimefromat function to convert it to your desired format.
DateTimeParse([Date],'%m/%d/%Y %H:%M')
DateTimeFormat([newdate],'%d/%m/%Y %H:%M')