concatenate date / time

[SwingeyP]

Hi. 

I have a spreadsheet with columns 'date of delivery' and 'time of delivery'.

I want to concatenate these two fields in the dataflow to produce one date/time field.

I appreciate that the fields have to be text to concatenate them. Can anyone provide me with a script to do this please?

Here's what I have : 

#"Added custom 2" = Table.AddColumn(#"Changed column type 1", "Custom", each Time.ToText([crf79_timeofdelivery]) & [Date of Delivery Attempt])

Expression.Error: We cannot apply operator & to types Text and Date.

Details

Operator = &

Left = 10:30

Right = 7/15/2020 12:00:00 AM

[SwingeyP · Accepted solution]

Sorted 🙂

#"Added custom 2" = Table.AddColumn(#"Changed column type 1", "Custom", each Date.ToText([Date of Delivery Attempt]) &" "& Time.ToText([crf79_timeofdelivery])),