Concatenating Date Time Fields and Calculate Hours

[prees959]

HI,

I have the following fields in my dataset :

DateTime Ordered  : which is in the format 31/01/2018  09:22:58

Date Deivered   :    which is in the format  01/02/2018  00:00:00

Time Delivered   :  which is in the format 08:00:00

What I need to do is combine the Date Delivered and Time Delivered find out the hours between the Date Delivered and Date Ordered.

Appreciate any advice,

Phil

[YoussefBelloum]

Hi,

on which field you want to combine these informations ? on the Date Delivered ?

Date Delivered = 01/02/2018 08:00:00 ??

[prees959]

Hi,

Yes.  The Date Ordered already has the time attached.

Many thanks,

Phil

[YoussefBelloum]

On the Script, try this:

Timestamp(Timestamp#(left([Date Deivered],10)&Right([Time Delivered],8),'DD/MM/YYYYhh:mm:ss'),'DD/MM/YYYY hh:mm:ss') as [Date Deivered]