Add in a report

[Pappy]

I'm sure this is simple but I keep getting #error. I have field being pulled from a qry called Send in ##/##/#### date format. I want to either add 30 to it, or use Date Add.

[Send] + 30
dateadd("m",1,[Send])


All is appreciated

 

[Pat Hartman]

If you are doing this in the controlSource of a control, you need to prefix the expression with the equals sign:

=dateadd("m",1,[Send])

Make sure that the name of the control is something other than Send. Rename it if necessary.