In either case, by using this code, it should take the result and store it in the table in the field I need it to? Also, under what sub do I put the code (ie AfterUpdate for the field where I manually put in the date?)
--- In [email protected], Dennis Jensen <[EMAIL PROTECTED]> wrote: > > And if that is not quite what you want then you can > extract date parts using the various Date Functions. > > intMonth = Month(date) > returns the month (1 to 12) as an integer > intDay = Day(date) > returns the day of the week as an integer > intYear = Year(date) > returns the year part as an integer > > --- [EMAIL PROTECTED] wrote: > > Here's the function you'll need: > > dateadd("m",3,<your date field>) > > if you use -3 in the second parm, it will subtract 3 > > months. > > You can use it in code or in an update query. > > Hope it helps! > > LaDeana > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessVBACentral/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
