How to concatenate date and time
I have data with two columns; a date and a time stamp.
The timestamp is in AM/PM, but the convert functions do not work. AMtoPM parsing gives problems because the data contains both 12AM/PM. The parsing function can only deal with values 0-11.
How can I combine these columns into one column with date + time?