separate the date field into multiple column

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

Accepted answers

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...

Use \s as your delimter and that should work for you

I also try it but it don't work

Apologies i had the slash the wrong way round (have updated original post) - if you use \s it should work. Doesn't matter what the data type is.

That shouldve worked. If its a date format, you can use regex as well '(.*)\s(.*)\s(.*)'

i realy don't know why it does not work.

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...