Hi community,
I am unable to transform a data set date format from yyyy.mm.dd to dd/mm/yyyy eg: 2020.01.01 to 01/01/2020.
I tried to use select tool and change data type to date - is going to become null that column, I tried regex formula as in pictures but the outcome is null as well... perhaps I am missing something.. or I have to use a different tool?
I attached the original excel file as well.
Many thanks,
M.
Solved! Go to Solution.
Hi @Tmanuela I mocked up a workflow let me know what you think? Alteryx only recognises YYYY-MM-DD as a date data type hence why when you select that data type in the select tool the values then become null. You can transform the date into DD/MM/YYYY format however it would need to be a string field in Alteryx.
Hi @Tmanuela
Sorry for the late reply previously your post appeared and disappeared all of a sudden from the discussion board.
Here is a workflow for the task.
Output:
Workflow:
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
hi @atcodedog05 thanks for your help, are you ready to help get to the next challenge with multirow formula? i'll post a thread now.
Regards,
M
Hi @Tmanuela
Feel free to post if not me some will definitely help you out🙂
Community is filled with amazing users😀
But it stores the formatted date cell in string data type, when I use this method and try to change format to date it shows null.
I wanted to know if we can change format to dd/mm/yyyy with date data type