Default Date plus 14 days

[AmyLynnHill]

I'm want to create a field in a table based off of another field and add 14 days. Some of the records are blank.

I tried to put the following syntax in the default value field of the calculated field. [DateMailed]+14 this didnt work
I also tried an if statment

Iff ([DateMailed]not null, [DateMailed]+14, "not Mailed yet").

any ideas?

 

[boblarson]

You shouldn't be putting this in a table as it can be calculated on the fly with a query (normalization violation).

In a query you can have a field like:

MyDateFieldName:IIf(IsNull([DateMailed]),Cstr(DateAdd("d",14,[DateMailed])),"Not Mailed Yet")