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 |
|
galbrecht
Starting Member
17 Posts |
 Posted - 2010-01-17 : 17:26:45
|
| HiI would like to know how to select * that is older than say two weeks (14 Days) from a given date.The query below selects * that is 14 days from today using the getdate function. I would like to be able to use that same query but insert a from date like 01/01/2010.SELECT request.sys_request_id, CONVERT(varchar(10), request.sys_requestdate, 103) AS sys_requestdate, request.sys_eusername, request.sys_requesttype_id, request.sys_problemdesc, request.sys_solutiondesc, request.sys_requeststatus, request.sys_requestclosedate, status.sys_status, request.sys_assignedto, DATEPART(yyyy, request.sys_requestdate) AS Expr1, DATEPART(mm, request.sys_requestdate) AS Expr2, DATEPART(dd, request.sys_requestdate) AS Expr3, request.sys_requestdate AS Expr4, requesttype.sys_requesttypeparent_id, requesttype.sys_requesttype_id AS Expr5FROM request INNER JOIN status ON request.sys_requeststatus = status.sys_status_ID INNER JOIN requesttype ON request.sys_requesttype_id = requesttype.sys_requesttype_idWHERE (NOT (request.sys_requeststatus = 0)) AND (request.sys_requestdate <= GETDATE() - 14) AND (requesttype.sys_requesttype_id LIKE N'%Origen%') OR (requesttype.sys_requesttype_id LIKE N'Clear Lock File') OR (requesttype.sys_requesttype_id LIKE N'Import SR File') OR (requesttype.sys_requesttype_id LIKE N'%Ozone%') OR (requesttype.sys_requesttype_id LIKE N'Change Origen Access')ORDER BY Expr1, Expr2, Expr3, sys_requestdateyour help will be much appreciatedRegardsGreg |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-01-17 : 20:58:22
|
[code]request.sys_requestdate <= dateadd(day, datediff(day, 0, getdate()), -14)[/code]
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
|
|
Get Date