toughest general question ever(date/time picker)!

[titan7262]

i am using MS ACCESS as my database and a date/time picker. the problem is if the value of the date/time picker is at 12:00:00 the it returns only the date.
i.e
if the value of btpTo is 01/01/2004 12:00:00 am it only retuns 01/01/2004 which is the date. the problem is i nee to get the exact date/time. any one has an idea on this?! hehehe





to be clear.

my database has:

fieldname: mydt
data type: date/time format: general date

my code in VB:

rs.open "select * from myDB where id = 1",cn,1,1
rs.addnew
rs!mydt = "12/12/2004 12:00:00 am"
rs.update

result when saved into dbase.

mydt(fieldname)
12/12/2004



time is missing! it should be 12/12/2004 12:00:00 am

[Arc]

try this forum http://www.vbforums.com/forumdisplay.php?s=&forumid=3

[titan7262]

sorry for the comment about ms access. what i mean is that i am having problems with datetimepicker. if the date is 01/01/2004 12:00:00 am it only returns 01/01/2004 time is missing what can i do

[akki]

As we know "01/01/2004 12:00:00" and "01/01/2004" are one and the same. Whats your porblem if it does not return time then?

[Arc]

You could just fill in the blank. See if the time is there, if it's not then add 12:00:00 to the string.

[titan7262]

i need the whole values in my report. it's not a good idea if i just give the date and not time.

[akki]

try this

MsgBox Format(DTPicker1.Value, "MM/DD/YYYY HH:MM:SS AM/PM")