Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to add two fields as one DateTime field?

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:MMSmiley FrustratedS)

Any help is appreciated.

Thanks,

10e5x

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

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

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


talk is cheap, supply exceeds demand
5 Replies
Not applicable

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

Hi,

You can concatenate the two fields to make one field:

Event_D & ' ' & Event_T as EventDateTime

Hope this helps.

Regards,

Neha Rangari

jagannalla
Valued Contributor III

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

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

MVP & Luminary
MVP & Luminary

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

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


talk is cheap, supply exceeds demand
Not applicable

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

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

Not applicable

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

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

Community Browser