topic Date conversion in QlikView

Date conversion

jagjivvt — Thu, 15 Mar 2012 09:40:38 GMT

How do i change this date format 3/12/2012 2:09:54 PM to 12/03/2012

thanks

vijay

eliran — Thu, 15 Mar 2012 09:44:14 GMT

Hi vijay,

You can use the Date() function:

Date(invoiceDate,'MM/DD/YYYY')

Hope it helps,

Eliran.

jagan — Thu, 15 Mar 2012 09:52:24 GMT

HI,

I think 3/12/2012 2:09:54 PM is in M/DD/YYYY hh:mm:ss TT format.

If so, then use the following expression

= Date(Date#('3/12/2012 2:09:54 PM', 'M/D/YYYY hh:mm:ss TT'), 'DD/MM/YYYY')

HOpe this helps you.

Regards,

Jagan.

jagjivvt — Thu, 15 Mar 2012 09:58:44 GMT

thanks Jagan, it works

CELAMBARASAN — Thu, 15 Mar 2012 10:00:15 GMT

Hi,

Try with this

Date(Floor(Date#('3/12/2012 2:09:54 PM','M/DD/YYYY h:mm:ss TT')),'DD/MM/YYYY')

Celambarasan

jagjivvt — Thu, 15 Mar 2012 10:45:23 GMT

Jagan

Thanks, it worked

Regards

Vijay