Results 1 to 9 of 9

Thread: Date Type with VB and Access[Resolved]

Threaded View

  1. Jan 24th, 2005, 01:47 PM #1
    trackdaychamp
    trackdaychamp is offline

    Thread Starter
    Junior Member
    Join Date
    Jan 2005
    Posts
    17

    Date Type with VB and Access[Resolved]

    I want to take an inputted date from a text box, convert it to a date datatype then send it to my access database.

    The data type of the Access field was text and then date, both of which didnt record the correct figures.

    My program is sending the data to the db but it is captured incorrectly. i.e. Its being stored as an abstract time (00:00:43) or code(4.99001996007984E-04).

    Heres my code:

    Dim dtRentalDate as Date

    If txtRentalDate.Text = "" Then
    dtRentalDate = Now()
    Else: dtRentalDate = txtRentalDate.Text
    End If


    Please help
    Last edited by trackdaychamp; Jan 24th, 2005 at 05:03 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width