I have the following code that writes the Date to a mySQL DB:
However, the date that is returned is:
Month is dodgy
Should be: 04/01/2026
B4X:
Dim myID As String = deviceID
Dim myDate As String
DateTime.DateFormat = "dd/mm/yyyy"
myDate = DateTime.Date(DateTime.Now)
SQL.ExecNonQuery2("INSERT INTO regdevices (deviceid, regdate) VALUES (?, ?)", Array(myID, myDate))However, the date that is returned is:
B4X:
04/30/2026Month is dodgy
Should be: 04/01/2026