Power Platform Community Forum Thread Details

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

Categories:

concatenate date / time