Hi! here i' am again. I just want to ask for ur help.

Im having difficulties converting string data into time

Ex: string data : "0920"
Expected result in time: 9:20

I tried using cdate function, but it doest work well.
by the way im using VB6.

Please help me with this, i really need to finish my project ASAP. Guys, you are my only hope.

Thanks A lot

Hi,
For the example you've given, try the following:

dim dt as date dim s as string s="920" dt = cdate(format(s,"00:00"))

Hope this helps,
Kieron


____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)

thanks for always enlighten me.  

Hi x_router,
Can you mark this as Solved if you are happy.
thanks
Kieron


____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)