Convert date from yyyy.mm.dd to dd/mm/yyyy

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.

Date Time

Accepted answers

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.

Date_03112020.yxmd

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 😀👍

All comments

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.

Date_03112020.yxmd

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 😀👍

Hello,

I used datetime converte to convert date :

2- Date time format to formate the date

Attache the workflow.

Hope that help

Regards,

DateConvertCommunity.yxmd

Happy to help 🙂 @Tmanuela

Cheers and Happy Analyzing 😀

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

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15878

MarqueeCrew 13708

apathetichell 13703