topic Date/time format in QlikView

Date/time format

Mon, 18 Feb 2013 04:01:41 GMT

Hi all,

I'm trying to format the following date-time format, but nothing so far has worked.

Current format . eg. :31/AUG/11 01:57:39.000000000 PM

I've tried this expression with no luck : date(floor(timestamp#(CALL_DATETIME,'DD/MMM/YY hh:mm:ss')),'DD/M/YYYY') as CallDateTime

Any ideas on how to achieve the date format : DD/MM/YYYY hh:mm:ss ?

Many thanks

sivarajs — Mon, 18 Feb 2013 04:36:16 GMT

=date(date#('31/AUG/11 01:57:39.000000000 PM','DD/MMM/YYYY hh:mm:ss.[fff] TT'),'DD/MM/YYYY hh:mm:ss')

Mon, 18 Feb 2013 04:53:34 GMT

Thanks Sivaraj!