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 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?