Date Functionality

[nathan]

I need to copy one date from a field to another field but once it is
copied i need to perform a function on it to add 11 months. This needs
to be done within a form. The fields are within the same table.

Does anyone know how to do this?? Thanks in advance if anyone can
help.

Regards
Nathan

[Stewart Allen]

Hi Nathan,

In the control source of the second field on the form type the following
function:
= DateAdd("m", 11, [FirstFieldName])
This is a standard Access function that adds dates and times. The first part
is the interval; m=month, yyyy=year, d=day. The second part is the number
and the third part is the field which holds the date/time value to make the
calculation from.

Make sure that the second date field is not bound to a table, the first date
field should be bound and stored in the table.

Stewart
"nathan" <na****@goldhillsonline.com> wrote in message
news:6e*************************@posting.google.co m...

I need to copy one date from a field to another field but once it is
copied i need to perform a function on it to add 11 months. This needs
to be done within a form. The fields are within the same table.

Does anyone know how to do this?? Thanks in advance if anyone can
help.

Regards
Nathan