Adding Days to a 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.

 

[Brendan Reynolds \(MVP\)]

SELECT DateAdd("d",180,[Effective Date]) AS TheDate
FROM Table1;