Results 1 to 4 of 4

Thread: Database

  1. #1
    Join Date
    Dec 1969

    Default Database

    I am trying to enter info into a database based on the date but it isnt working. Anyone who may help is greatly appreciated. Here is my code. <BR><BR>If Time() &#060;= CDate("12:00 AM") Then <BR>rsQuery("count") = rsQuery("count") + 1 <BR>rsQuery("date") = Date() <BR>rsQuery.Update <BR>Else <BR>rsQuery.AddNew <BR>rsQuery("count") = rsQuery("count") + 1 <BR>rsQuery("date") = Date() <BR>rsQuery.Update

  2. #2
    repost hater Guest

    Default STOP REPOSTING!!!!!!!!!!!!


  3. #3
    vague Guest

    Default what is not working?<eop>


  4. #4
    the other steve Guest

    Default RE: Database

    i dont use () after date.<BR><BR>i used rs("temp")=int(date), though you probably just need<BR><BR>rs("temp")=date [i didn&#039;t want the time - it was causing me formatting problems later]<BR><BR>I&#039;m not really an expert at this stuff, but that&#039;s how I got the current date into a record.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts