Date and Time Separator

[EmilAlteryx01]

I’d like to separate the September column into two distinct columns: one for the "September date" and another for the "September time"

Email Address	September	Status
Alex.123456@gmail.com	8/21/2024 1:28:12 AM	Red
Alex.123456@gmail.com	8/24/2024 1:17:04 AM	Amber
Alex.123456@gmail.com	8/21/2024 1:28:12 AM	Green
Alex.123456@gmail.com	8/19/2024 8:29:48 AM	Red
Alex.123456@gmail.com	08/07/2024 01:05:31	Amber
Alex.123456@gmail.com	08/02/2024 12:19:22	Green
Alex.123456@gmail.com	09/05/2024 12:36:45	Red
Alex.123456@gmail.com	09/11/2024 12:19:32	Amber
Alex.123456@gmail.com	8/13/2024 2:04:10 PM	Green
Alex.123456@gmail.com	09/10/2024 21:11:10	Red

[binuacs · Accepted solution]

@EmilAlteryx01 

[EmilAlteryx01]

Thank you .. .This solution worked