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

__________________
yvk