Hi guys,
first time asking so please excuse if I can’t formulate it in the “proper” way or miss out important information
I’m using ParseDate to convert a string which has a date & time in it (8/1/2013 16:31:06) into a date variable. The function returns TRUE and contains the correct date (8/1/2013) but not the correct time (0:00:00). What is wrong with this code?
Dim sValue As String
Dim dtJoin_Date As Date
If ParseDate(sValue, dtJoin_Date) = FALSE Then
MsgBox ("Error 2 - wrong date format")
Return FALSE
End If
Long time is set to H:mm:ss in the region and language of my Windows computer
Thanks in advance,
Andreas