Android Question Strict three-letter month names in formatted dates

[Brian Dean]

I am storing dates in integer variables as a "day value" - ie whole days derived from normal DateTime values. I convert these values to text as follows :

Private Sub dayToDate(day As Int) As String
    DateTime.DateFormat = "dd MMM yy"
    Dim conv As Long = day
    Return DateTime.Date(conv * 24 * 3600 * 1000)
End Sub

However dates in September are being formatted with "Sept" (four characters) which is giving me a problem as I have room for only three characters ("Sep"). From what I read MMM should specify a three-letter month name. Have I overlooked something?

 

[mangojack]

Problem DateTime.DateParse if date contains Sep

I am importing .csv files into SQLite and need to convert dates in the format dd-MMM-yyyy into Excel dates. I have a simple Sub for this: Public lTicksOff As Long 'this is set in various Subs, eg InitApp: lTicksOff = DateUtils.SetDate(1970, 1, 1) Public...

www.b4x.com

Additional posts in this thread are worth a read as well.