Hi,
I am trying to convert incoming string field DD.MM.YYYY into MM/DD/YYYY. But Date Time conversion tool is giving me null column.
Can you help?
Thanks
Solved! Go to Solution.
Hi @rajputakansha ,
For that, the custom expression needs to be dd.MM.yyyy
Also, if you want to use the format MM/DD/YYYY, keep in mind that it is not possible to keep this format as a date type column, as the only accepted date format in Alteryx is yyyy-mm-dd
Let me know if that works for you.
Best,
Fernando Vizcaino
Hi @rajputakansha ,
why not use a Formula tool? If you convert the incoming string to a date format (function DATETIMEPARSE will do that) you can format it to any format you need using DATETIMEFORMAT (resulting in a string). So tailored to your probem, a formula like
DateTimeFormat(DateTimeParse([Date], '%d.%m.%Y'), '%m/%d/%Y')
would do the job. A sample workflow is attached. Hope this is helpful.
Best,
Roland
I've needed to do this before. Even though Alteryx doesn't read this type of date format, I needed it for my output. This is what I did.
1. Change what you wrote to dd.mm.yyyy
2. Use the same tool again separately, but instead of the default string to Date/Time format, choose 'Date/Time to string.' Than yo ucan specify the output you'd like your date string to look like (ie. mm/dd/yyyy).
Please let me know if this helps you by accepting as solution. If not - good luck with you endeavors.
Thanks,
Jacob