Date issues adding an extra day.

[Neozero]

I am trying to run an update statement that will add one day to a specific date field. Here is my update statement.


update employee
set empenddate = empbegindate +1
where empbegindate = empenddate

I don't know how to add an extra day to the empbegindate field. What I am trying to do is add an extra day to the empenddate because I have records that have the same dates in each field.


zero

 

[JayKusch]

set empenddate = DateAdd(Day,1,empbegindate)


Thanks

J. Kusch

 

[JamesLean]

FYI,
You can use the DATEADD function as Jay says, but actually your original query is perfectly valid. If you're adding days then you can use simple addition like that.

--James