topic Re: How to add two fields as one DateTime field? in QlikView

How to add two fields as one DateTime field?

Fri, 20 Nov 2020 18:02:30 GMT

Hi all,

I have two fields: Event_D and Event_T. My db is microsoft access 2003. These two fields are text data type.

How can i make this two field into a datetime field in QlikView? Not sure of the syntax.

E.g. Event_D: 01/05/2012 (text)

Event_T: 06:17:09 (text)

What i wish to achieve

EventDateTime : 01/05/2012 06:17:09 (DD/MM/YYYY HH:MM:SS)

Any help is appreciated.

Thanks,

10e5x

Re: How to add two fields as one DateTime field?

Mon, 03 Dec 2012 07:52:24 GMT

Hi,

You can concatenate the two fields to make one field:

Event_D & ' ' & Event_T as EventDateTime

Hope this helps.

Regards,

Neha Rangari

Re: How to add two fields as one DateTime field?

jagannalla — Mon, 03 Dec 2012 07:57:14 GMT

Hello,

Try this

Timestamp(Timestamp#(Event_D & ' '& Event_T,'DD/MM/YYYY hh:mm:ss'),'DD/MM/YYY hh:mm:ss') as EventDate

Cheers!!

Jagan

Re: How to add two fields as one DateTime field?

Gysbert_Wassenaar — Mon, 03 Dec 2012 07:57:57 GMT

Try: timestamp#(Event_D & ' ' & Event_T,'DD/MM/YYYY hh:mm:ss') as EventDateTime

Re: How to add two fields as one DateTime field?

Mon, 03 Dec 2012 08:00:38 GMT

use Date#( DateField, 'M/D/YY') as Date

Re: How to add two fields as one DateTime field?

Mon, 03 Dec 2012 08:13:44 GMT

Hi all,

Thanks for all our replies. will try each as soon as possible. Currently faced with a very difficult problem, have to overcome before i continue. Gysbert may be aware of my problem, haha. The way i derive my working hours are totally wrong. Feel like asking the pros through QlikView but it will be a sql question not really QlikView. Should i even ask?

Troubled,

10e5x