I need to send date and time to access database
I am using OLEDB adaptor
when i set field "date"=now it updates only date but not time in the database. What is the right command syntax

yvk

__________________
yvk

hi there..

are you sure that you are not sending everything?? take in mind that sometimes access doesn't show all the data inside a field because of display issue... "now" should pass the date and time to the database... if not try adding a fixed date and time to see what happens...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========

Access delineates dates with pound signs in queries.
Are you opening a recordset and setting the value of that recordsets fields to Now(), or are you using a query with “UPDATE . . . ” or “INSERT INTO . . . ”?

here is the full code
I am still not successful in sending date and time , in Access
Database. Access database field for "mdate" is set to DataType = date/time and Format = GeneralDate
after update "mdate" has date but no time (example 5-23-07)
NOT( 5-23-07 1:07:00 AM))

      Dim newrow As dsLearnVB.costRow
        Dim main As New Form1

        TextBox1.Text = Now
        TextBox2.Text = 29.99

        Try
            newrow = DsLearnVB1.cost.NewRow
            main.newrow = newrow
            newrow("cost") = Val(TextBox2.Text)
            newrow("mdate") = FormatDateTime(Now, DateFormat.GeneralDate)
'and have also tried newrow("mdate") =system.convet.todatetime(textbox2.text)
            DsLearnVB1.Clear()
            DsLearnVB1.cost.Rows.Add(newrow)
            daLearnVB1.Update(DsLearnVB1)

        Catch ex As Exception
            MessageBox.Show(ex.Message.ToString)
            newrow.CancelEdit()
        End Try


Additional Question
when cost field is set as data type number and format decimal
updates fills a value of 29.00 not 29.99
when i set the field to datatype double then it updates 29.99.
Can you explain this behavior too





yvk