Can't insert Time into ACCESS MDB with VB.NET

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Used everything: Now(); TimeValue(); Now.TimeOfDay() - nothing works! MDB stores default time 12:00:00 AM !!
Format() function didn't help too

BTW, Today() works fine and stores current date

What to do?
 
Hi Bob,

Can you show a piece of code?

(a row of 5 would be enough I think where that date is in)

Cor
 
dRow("OperationDate") = Today <- works OK (I see current date in MDB

dRow("OpTime") = Now() <- I see 12:00:00 AM in MDB, always! No format helps land functions like: Date.Now.TimeOfDay, Format(Now(), "hh:mm:ss")
 
Back
Top