convertion from string to time
I have a data base and time is stored as text in the database. From 8.00 to 18.00 with 30 min intervals. example 8, 8.30, 9.00, 9.30. I have to convert them to AM PM format.
i tried cdate didnt work. I googled and saw some atricles which were vague. MSDN articles topped the list of Ambiguity.
Had been trying for last 4 hours with no results. Feeling very low at the moment
last code i used
Dim dt AsDate
dt = CDate(Format(myvalue, "0:00")) and also
dt = CDate(Format(myvalue, "00:00"))
myvalue is in the string format
Will appreciate help