Date format problem

[ElaineRC]

I am setting my date fields to have a custom format of ddMONyy eg 10Jun05 which works fine in the UK & the US but in Japan the format is overridden and the dates come out like this: ddmyy eg 10605. Any ideas why this happens and how I can stop it?

Many thanks

[ElaineRC]

Incase anyone has the same problem this is the solution....

(you only need to do this once in your VB.net project)

If System.Globalization.CultureInfo.CurrentCulture.LCID.ToString = 1041 Then
CrystalDecisions.Shared.SharedUtils.RequestLcid = 2057
End If

1041 is the locale id for Japanese
2057 is the locale id for English (UK)
All IDs are here: http://www.w3schools.com/vbscript/func_setlocale.asp

Thanks for your help ;-)