For months, take a look at GOMONTH(). It can add/substract months.

For days, just add the number of days.

For weeks, add nWeeks * 7.

Vlad

>I want to know how to manipulate date fields. I know about Month(), and Year() functions, but I want to be able to add months, weeks, or months to a certain date and show the date. For example, if the field has today's date of {11/19/98}, and I want to add 3 months, I want the field to show 2/19/99. I am using VPF 6.
>
>TIA,
>Jim