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.

       

      Thanks,

      10e5x