|
-
Sep 28th, 2000, 02:15 PM
#1
Thread Starter
New Member
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?
-
Sep 29th, 2000, 04:46 PM
#2
Fanatic Member
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.
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
|