5 Replies Latest reply: Dec 3, 2012 3:14 AM by guoxiang RSS

    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.