topic Re: Concatenating Date Time Fields and Calculate Hours in QlikView

Concatenating Date Time Fields and Calculate Hours

prees959 — Fri, 09 Mar 2018 13:54:32 GMT

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 — Fri, 09 Mar 2018 13:58:36 GMT

Hi,

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

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

prees959 — Fri, 09 Mar 2018 15:44:17 GMT

Hi,

Yes. The Date Ordered already has the time attached.

Many thanks,

Phil

YoussefBelloum — Fri, 09 Mar 2018 16:01:59 GMT

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]