Thank you very much for the reply, the code works very well, but the datetime of this 2019-12-02T07:55:01.120950718+01 has missing time variable after spliting into date column and time column. So I wish to maintain the datetime format in the first row same as the second row as shown in the attachment, before spliting it into date and time. please how do I do it. Kindly see attachement below.