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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Complex For Me

Author  Topic 

jesus4u
Posting Yak Master

204 Posts

Posted - 2003-08-18 : 13:50:22
This is beyond me....
Look at the photo of my view please...

https://www.readysecure2.com/users/polajenkocom/images/combine.jpg

I want to get all records with a CreatedDate that is within the past 7 days. Can anyone help me do this?

Thanks

setbasedisthetruepath
Used SQL Salesman

992 Posts

Posted - 2003-08-18 : 14:03:52
Your graphic is huge, hard to see.

Generally you would include something like the following in your WHERE clause:

datediff(dd, CreatedDate, current_timestamp) <= 7

Jonathan
{0}
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-08-18 : 14:04:50
The image is almost unreadable. Could you post the CREATE VIEW statement? You might want to also post the CREATE TABLE statements, but that part might not be necessary.

Tara
Go to Top of Page

jesus4u
Posting Yak Master

204 Posts

Posted - 2003-08-21 : 15:49:25
thanks again I resolved the issue...

Alex Polajenko
Go to Top of Page
   

- Advertisement -