The above example uses 'Left' and 'Mid' functions to define the relevant character blocks I want to represent the year, month and day elements of my date, whilst the 'MakeDate' function creates the date value from the defined elements (e.g. 20,110,517,121,922.00 becomes 17/05/2011 in my example).
Remember that you will probably have to work around commas as characters in your data if you are working with strings rather than numeric values.
John's quite right in highlighting the possible use of other date functions; there are often multiple options available for use depending on your particular data set. Unfortunately, I was unable to utilise the date function in my scenario. Details of date/time or string functions can be found in the reference manual relevant to your implementation of QlikView.
Meanwhile, what exactly have you tried for your example string "01/01/2011 12:21:34"? If you post the relevant script here perhaps we can consider the syntax with you and help point you to a resolution.
I want to try your solution, but I don't know how, 'cause I've some problem in the script. Where have I put the comand LOAD load Timestamp#(ORIGINAL_FIELD, 'DD/MM/YYYY hh:mm:ss') AS NEW_TIMESTAMP_FIELD FROM ...?
I connect qlikview ro a ODBC and with a script I load data, using a select function. I don't know where insert the command load.