Sharepoint 2007 calculated Date field shows incorrectly in non-US region
- by Proforce
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.