Date and Time Seperator

[EmilAlteryx01]

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

[DataNath]

Hey @EmilAlteryx01, if all of your data follows the same pattern as the sample i.e. <Date><Space><Time><Space><AM/PM?> then you can go with something like:

//Sept Date:

GetWord([Sept_datetime_local], 0)

//Sept Time:

PadLeft(
GetWord([Sept_datetime_local], 1),8,'0')

[binu_acs · Accepted solution]

@EmilAlteryx01 another way of doing this with regex, since you have different type of date format to be split into date and time, the regex also changed accordingly

[binu_acs]

@EmilAlteryx01 if you want to change the date and time into a specific format you need to use the DateTimeParse() function