separate the date field into multiple column

[Khaled_Eid]

hi

I am khaled and I am new to working with Alteryx

how I can split the date field like This

2006-04-01 00:00:00.000 +0200

into three columns

I tried The text to columns tool to separate it and I filled the delimiter with space but it doesn't work

[Khaled_Eid]

that's it

[DavidSkaife · Accepted solution]

Ah ha! It's doing it for me as well, however, do you have the AMP engine switched on?

If you turn it off it works...

[MilindG · Accepted solution]