This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Every time I get the same result: After separation I get the string 2017/05/20 but then, when I apply the Date/Time Function, I get this result: 20-03-2017 00:05:00
Hi @dana_buz just reading the above it looks like you are specifying the field type to be a date/time within Alteryx. If this is the case it will always remain in the Alteryx date format of CCYY-MM-DD HH:MM:SS.
If you need the date to be formatted in a different way that's fine, you will just need to have the field type as a string. Do note that this will then mean they aren't able to be treated as dates in formulas and filters etc if you do something like [MyDate] > "2017-10-09".
The above post with the expression can be used in a formula to parse you field and then format it to the desired output.
Edit: oops just seen the original post is a little old. So that may no longer be relevant