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 |
|
Lord Dubu
Starting Member
12 Posts |
 Posted - 2004-06-02 : 08:14:19
|
| I need to build a dynamic query where users can specify the next ship date of an item. The catch is, the way the db was set up there is only column for the last ship date.Ship dates are 60 days apart. So using an asp page I am trying to do something like this:HAVING (COUNT(*) >= '9') and dateadd(dd,60,max(last_ship))= '"&nextShip&"'"The above query, was it working as I wanted it to, would return one customer at the moment who is in the 60 day window... |
|
|
Lord Dubu
Starting Member
12 Posts |
Posted - 2004-06-02 : 08:25:12
|
| Nevermind. Seconds after posting this I realized that I was formatting my date wrong in the asp page. This really isn't a SQL question at all, and was fixed in the ASP. |
 |
|
|
|
|
|
dateadd question