Date conversion

[jagjivvt]

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

thanks

vijay    

[eliran]

Hi vijay,

You can use the Date() function:

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

Hope it helps,

Eliran.

[jagan · Accepted solution]

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]

thanks Jagan, it works

[CELAMBARASAN]

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]

Jagan

Thanks, it worked

Regards

Vijay