Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chapmana
Starting Member
1 Post |
 Posted - 2009-06-30 : 09:38:04
|
| I have a novell network and am trying to run reports, it needs a query to make the results given filter.What i am trying to do is only show the entries which are over 45 days old from todays date. Can anyone help? |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-06-30 : 09:42:07
|
| where date_col>=dateadd(day,datediff(day,0,getdate()),-45)MadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Novell Pervasive SQL