Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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:MM:SS)

Any help is appreciated.

Thanks,

10e5x

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

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


talk is cheap, supply exceeds demand

View solution in original post

5 Replies
Highlighted
Not applicable

Hi,

You can concatenate the two fields to make one field:

Event_D & ' ' & Event_T as EventDateTime

Hope this helps.

Regards,

Neha Rangari

Highlighted
Partner
Partner

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

Highlighted
MVP & Luminary
MVP & Luminary

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


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Not applicable

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

Highlighted
Not applicable

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