Date / Time

[dhoward007]

I am having a problem calculating dates.

I have a field datetime and I need to delet records older than 60 days.. my query is something like this.


delete from table where statdate < dateadd(day, -60, getdate())


For some reason this doesn't work.. Can you give me some suggestions?

 

[SQLSister]

I tested your command on a test table of mine and it worked. However, I noticed that you used the field name statdate - did you mean startdate?

 

[dhoward007]

Sorry... I feel really stupid...


The query did work, I wasn't looking at the year so I though it wasn't working...


DUH!!!!!