I’d like to separate the September column into two distinct columns: one for the "September date" and another for the "September time"
@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
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 if you want to change the date and time into a specific format you need to use the DateTimeParse() function
