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 |
|
mlawton40
Starting Member
15 Posts |
 Posted - 2007-05-02 : 07:04:08
|
| Hey,Does anyone know how I could use a select statement to get the results where the recorded [date] is upto 4 weeks ago?Cheers, Mark |
|
|
pbguy
Constraint Violating Yak Guru
319 Posts |
Posted - 2007-05-02 : 07:13:45
|
| select * from table_name where date_column >= dateadd(week, -4, getdate()) |
 |
|
|
|
|
|
Using current date