Results 1 to 2 of 2

Thread: Getting the DateAdd function to Work

  1. #1

    Thread Starter
    New Member
    Join Date
    Sep 2000
    Posts
    9

    Question Getting the DateAdd function to Work

    I know how the DateAdd function itself works, but I just not sure how to work it in in Visual Basic. Here's the situation: I have a database in Access that contains a field called DateHired that is entered in using a form in Visual Basic. I also have a field called 3MonReview that I need to calculate using the DateAdd function. Where and how can I work the DateAdd function it to make this work?



  2. #2
    Fanatic Member
    Join Date
    Oct 1999
    Location
    England
    Posts
    982
    I would place the code to calculate the 3MonReview date (using the DateAdd function) in the lost_focus event of the
    DateHired control.

    The other option is to place the code in the DateHired Change event and on confirmation that a valid date has been entered fire the code that will perform the date calculation.

    I could be wrong but I think there is a function called ISDate() or someting like that.


    Things I do when I am bored: DotNetable

Posting Permissions

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



Click Here to Expand Forum to Full Width