Date formate changing in Italian settings
-
Hi all, I am facing problem in displaying the Date formate in Excel . From Database i am displaying the Date lets say the Formate "dd/mm/yy" e.g 03/05/10. nothing but (3rd May 2010) The above formate is displaying in correctly in English settings but when the client generating the excel, there it is displaying as "05/03/10" i mean day and month are interchanging. (Because they are using Italian settings due to this reason date is displaying like 05/03/10) Can any body help on this?Date formate should not interchange Thanks in advance, Balu.
-
Hi all, I am facing problem in displaying the Date formate in Excel . From Database i am displaying the Date lets say the Formate "dd/mm/yy" e.g 03/05/10. nothing but (3rd May 2010) The above formate is displaying in correctly in English settings but when the client generating the excel, there it is displaying as "05/03/10" i mean day and month are interchanging. (Because they are using Italian settings due to this reason date is displaying like 05/03/10) Can any body help on this?Date formate should not interchange Thanks in advance, Balu.
Perhaps this will help, http://msdn.microsoft.com/en-us/library/ht77y576(v=VS.100).aspx[^]
I know the language. I've read a book. - _Madmatt
-
Hi all, I am facing problem in displaying the Date formate in Excel . From Database i am displaying the Date lets say the Formate "dd/mm/yy" e.g 03/05/10. nothing but (3rd May 2010) The above formate is displaying in correctly in English settings but when the client generating the excel, there it is displaying as "05/03/10" i mean day and month are interchanging. (Because they are using Italian settings due to this reason date is displaying like 05/03/10) Can any body help on this?Date formate should not interchange Thanks in advance, Balu.
-
Hi all, I am facing problem in displaying the Date formate in Excel . From Database i am displaying the Date lets say the Formate "dd/mm/yy" e.g 03/05/10. nothing but (3rd May 2010) The above formate is displaying in correctly in English settings but when the client generating the excel, there it is displaying as "05/03/10" i mean day and month are interchanging. (Because they are using Italian settings due to this reason date is displaying like 05/03/10) Can any body help on this?Date formate should not interchange Thanks in advance, Balu.
I would leave it as is. They have Italian settings for a reason (are they Italian perhaps) so they will want dates to show in the Italian format. The only time I think it is legitimate to force a date format is with regard to American settings when coding for British users. Unfortunately Microsoft in their wisdom default English settings to be American English, even on editions of software produced specifically for the British market. Consequently many British people have American settings by mistake. This is especially a problem with SQL Server, which will not install in British English no matter how hard you try (causing no end of trouble with reporting services), and must be changed afterwards. In fact only the execution language can be changed, the root installed language settings cannot be changed! All other culture settings should be respected.
If you have knowledge, let others light their candles at it. Margaret Fuller (1810 - 1850) [My Articles] [My Website]