How to add two fields as one DateTime field?

[#1]

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

[#2]

Hi,

You can concatenate the two fields to make one field:

Event_D & ' ' & Event_T as EventDateTime

Hope this helps.

Regards,

Neha Rangari

[jagannalla]

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

[Gysbert_Wassenaar · Accepted solution]

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

[#5]

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

[#6]

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