Change Date Format not Working in English (United Kingdom)

Hi,

I have created following rule to change date format to DD Month YYYY. [=text(todatetime(split(ri!inputDate," ")[1]),"dd mmm yyyy")] This rule works fine if user's language is English (United states ) and if I change language English (United Kingdom) I a facing following issue :
11/25/2013 11:00 AM will be converted correctly 25 Nov 2013 as Date is greater than 12
12/02/2013 08:00 PM will be converted to 12 Feb 2013 this is wrong actually date is 02 Dec 2013

Any pointers to correct this would be helpful. I can’t change language preference.

Thanks,
Pooja
...

OriginalPostID-121038

OriginalPostID-121038