Adding 9 months

[Guest]

Hello,

I found that is possible to include a calculated fields in forms by the
control source property box. I try to find the right expression for adding 9
months in a one certain date (date of publication, other field in form/table).

I tired this, but it doesn't work =[Date of publication]+Month(9)

Please help - many thanks

 

[Guest]

=DateAdd("M",9,[Date of publication])

 

[Brendan Reynolds]

=DateAdd("m",9,[DateOfPublication])

See 'DateAdd Function' in the help files for details.

 

[Guest]

=DateAdd("m", 9, [Date of publication])