Extracting Data Where Tomorrow's Date Is Used

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

General SQL Server Forums

New to SQL Server Programming

Extracting Data Where Tomorrow's Date Is Used

Author

Topic

KingCarlos
Yak Posting Veteran

74 Posts

Posted - 2009-10-25 : 22:38:40

Hi, I am trying to have a report built which gets the next_call_date a day before the next call date.

In otherwords the report is run today, October 26 2009 and I want it to capture all data that has the value of October 27 2009.

And then the day after October 27 2009 and I want it to capture all data that has the value of October 28 2009.

How do I build such a sql query

KingCarlos
Yak Posting Veteran

74 Posts

Posted - 2009-10-25 : 22:56:57

Actually thinking I can have it built on the same date earlier monring so that the report can be sent before office hours

The problem with this SQL Script is that the getdate includes the time whereas the next_call_date format is YYYY-DD-MM

select next_call_date, * from contacts
where next_call_date = getdate()

I was also fooling arou8nd with this sql script

select next_call_date, * from contacts
where next_call_date = dateadd (d,1,getdate()ltrim,10))