add days to date

[Jeff]

I am building a field expression in which I want to take
the date out of the "Effective Date" field and add 180
days to it. Below is the expression I have built,
however, when running the query I am getting an error in
the newly created field. Any help would be appreciated.

=[Effect Date] + 180

 

[Guest]

Just use the dateAdd function.

=dateAdd("d",180,[effect Date])

this should work. The "d" represents the DAys. for a quick
reference press F1 anywhere on the word DateAdd to get
more help on this function.

Good luck,
PAtrick

 

[Guest]

Hi,

Try adding a text box to your table called date and add it
to your form. Change control source to =Now()+180 and
Format to Short Date.

James

 

[George Nicholson]

In addition to other suggestions:

Check for typos.

You say you want to update the Effective Date field but your formula
references the Effect Date field. Does that field exist? If it does I
would think that your original approach should work.