Combining separate date and time columns to make ISO 8601 format (yyyy-mm-ddThh:mm)
I am trying to generate a ISO 8601 formatted column, which combines two sepatate date and time columns into a joint date/time form (yyyy-mm-ddThh:mm). Here is an example: DATE (yyyy-mm-dd)TIME (:day:hr:m:s)DATE/TIME (yyyy-mm-ddThh:mm)2000-07-20:0:09:30:002000-07-20T09:301993-04-30:0:12:01:001993-04-30T12:012003-05-05:0:16:28:002003-05-05T16:28 I have tried to simply change the format for the "TIME...