Returns a date to which a specified time interval has been added.
DateAdd(interval, number, date)
MsgBox DateAdd("d", -365, Date) 'Returns a date 365 prior to current date
Look in help under DateAdd for all the interval formats.
Hop this helps...
Kenny Alligood
|