Q:

Sharepoint 2007 calculated Date field shows incorrectly in non-US region

If a SharePoint user (with Regional Settings set to UK) views a calculated date field in a View details form, the field shows incorrectly.
I am using: 
ddwrt:FormatDateTime(string(@RenewalDate), 1033, 'dd MMMM yyyy')
Which shows 04 January 2010 for 01/04/2010 and, doesnt show unresolvable dates such as 31-Dec-2010.
This applies even with a simnple =[Modified] formula
The Server is set up in the US for that locale.

A:

could you change the formula as simnple =[Today] and check doest it works?
please try with the below formula
=IF(NOT(ISBLANK([Modified])),DAY([Modified])&" "&TEXT([Modified],"mmm")&" "&YEAR([Modified]),"") 

And it is working fine for me. Pls try it and let me know what you are getting.

