Date time

Hi All

I have 2 columns. First column contain Date (i.e. 13/01/2018). Second column contain time (10:00:00). I would like to combine these two columns to one column with both date and time i.e. 13/01/2018 10:00:00.

Do you have any suggestion?

Hi @kengdeb -

If your data is in string format, then you could use the String Manipulation node to join the two strings together, followed by a String to Date&Time node.

Like this


Then

Format needs to be modified to correspond to your data presentation.

2 Likes

Thanks a lot

1 Like