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 :
Solved! Go to Solution.
Sorted 🙂
#"Added custom 2" = Table.AddColumn(#"Changed column type 1", "Custom", each Date.ToText([Date of Delivery Attempt]) &" "& Time.ToText([crf79_timeofdelivery])),
Sorted 🙂
#"Added custom 2" = Table.AddColumn(#"Changed column type 1", "Custom", each Date.ToText([Date of Delivery Attempt]) &" "& Time.ToText([crf79_timeofdelivery])),
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
190 | |
70 | |
50 | |
37 | |
27 |
User | Count |
---|---|
243 | |
114 | |
91 | |
91 | |
69 |