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')
@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
@EmilAlteryx01 if you want to change the date and time into a specific format you need to use the DateTimeParse() function