I have a date column in an SQLite database. One record has a date of June 30, 2013. I want to use the following code to display the date:
So, if I set:
Then the date is displayed as 2013-06-30. All good.
But as I want to display the date as "30 Jun 2013" I set:
The problem is that after this the date is displayed as 30 Jan 2013...the month of June has been replaced with January!
B4X:
DateTime.Date(myDateValue)
So, if I set:
B4X:
DateTime.DateFormat = "yyyy-mm-dd"
Then the date is displayed as 2013-06-30. All good.
But as I want to display the date as "30 Jun 2013" I set:
B4X:
DateTime.DateFormat = "d MMM yyyy"
The problem is that after this the date is displayed as 30 Jan 2013...the month of June has been replaced with January!