Android Question Date Problem Excel

[peggjones]

Hi All

I'm having a problem with the following line of code

date1 = assetsheet.GetCellValue(1, i) - the cell contains 30/12/2013

When I run my program on one of my devices this value is changed to 12/30/13 on the other it remains 30/12/2013.

date1 is defined as string. The date setting is dd/mm/yyyy on both devices.

Any ideas?

 

[LucaMs]

Hi All

I'm having a problem with the following line of code

date1 = assetsheet.GetCellValue(1, i) - the cell contains 30/12/2013

When I run my program on one of my devices this value is changed to 12/30/13 on the other it remains 30/12/2013.

date1 is defined as string. The date setting is dd/mm/yyyy on both devices.

Any ideas?

may be dd/MM/yyyy? month in uppercase?

 

[Erel]

What is the excel field type?

Try to set the default locale with this code:

Dim jLocale As JavaObject
jLocale.InitializeStatic("java.util.Locale")
Dim usLocale As JavaObject = jLocale.GetField("US")
jLocale.RunMethod("setDefault", Array As Object(usLocale))