add days to date

  • Thread starter Thread starter Jeff
  • Start date Start date
J

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
 
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
 
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
 
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.
 
Back
Top