It might be a dumb question but I can't find an answer.
I have a simple code
Dim l As Long
The following problems occurred when I formatted the date:
Dim currentTime As String
DateTime.DateFormat = "EEE, dd MMM yyyy HH:mm:ss z" 'The expected : Tue, 30 Jul 2019 08:39:29 GMT
currentTime = DateTime.Date(DateTime.Now)
Log(currentTime) 'My system language is Chinese...
I know this been discussed here quite a few times, but I still am unable to format an SQL date field as I desire, it keeps showing me the date as yyyy-mm-dd...
I tried the following code and the result is always the same: yyyy-mm-dd
DateTime.DateFormat = "dd/MM/yyyy"