asked on
Dim sqlResult As OleDbDataReader
sqlResult = sqlCommand.ExecuteReader()
While sqlResult.Read()
myYear = CStr(Year(sqlResult.GetDateTime(0))).Substring(2, 2)
If Month(sqlResult.GetDateTime(0)) < 10 Then
myMonth = "0" + CStr(Month(sqlResult.GetDateTime(0)))
Else
myMonth = CStr(Month(sqlResult.GetDateTime(0)))
End If
If Day(sqlResult.GetDateTime(0)) < 10 Then
myDay = "0" + CStr(Day(sqlResult.GetDateTime(0)))
Else
myDay = CStr(Day(sqlResult.GetDateTime(0)))
End If
myDate = myDay + myMonth + myYear