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/
