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 |
|
mcupryk
Yak Posting Veteran
91 Posts |
 Posted - 2011-04-19 : 14:51:12
|
| delete |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-04-19 : 14:58:21
|
| [code]SELECT DATEDIFF(dd,OpenDate,GETDATE());[/code] |
 |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-04-19 : 15:13:07
|
| Looks good to me. The only thing you may want to consider that I can think of is whether you want the count to be inclusive of both days or not. If you do, you would need to add one. |
|
|
|
|
|
|
delete