Android Question Date Problem Excel

peggjones · Dec 31, 2013

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 · Dec 31, 2013

peggjones said:
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 · Dec 31, 2013

What is the excel field type?

Try to set the default locale with this code:

B4X:

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

Android Question Date Problem Excel

peggjones

Active Member

LucaMs

Expert

Erel

B4X founder

Android Question Date Problem Excel

peggjones

Active Member

LucaMs

Expert

Erel

B4X founder

Privacy & Transparency

Privacy & Transparency