format problem using msacess database

microsoft.public.dotnet.framework.adonet

24 Feb 2006 10:06 AM

hi iam using vs.net 2003, vb.net,Ado.net
msacess, a field is date/time
and format dd-mmm-yy hh:nn:ss

when i try to use this

dr("insp_datetime") = Format(Convert.ToDateTime(D), "dd-MMM-yy HH:mm:ss")
but the data in msaccess looks like this
24-Feb-06 0:00:00
i want to appear in like this 24-Feb-06 14:20:54

any formating iam missing....

thanks

24 Feb 2006 10:10 AM

sorry where D is
Dim D As Date
D = f ' note F looks like Thu, 16 Feb 2006 14:11:29

Show quote

"rt" wrote:

> hi iam using vs.net 2003, vb.net,Ado.net
> msacess, a field is date/time
> and format dd-mmm-yy hh:nn:ss
>
> when i try to use this
>
> dr("insp_datetime") = Format(Convert.ToDateTime(D), "dd-MMM-yy HH:mm:ss")
> but the data in msaccess looks like this
> 24-Feb-06 0:00:00
> i want to appear in like this 24-Feb-06 14:20:54
>
> any formating iam missing....
>
> thanks