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 |
|
csphard
Posting Yak Master
113 Posts |
 Posted - 2007-06-15 : 14:59:13
|
| DateDiff(DateInterval.Day, strAnnDt, dtNow)I thought if I used a datediff it would account for leap years.Is there anything extra I have to do for leap years.howard |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-06-15 : 15:09:21
|
| nope_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
csphard
Posting Yak Master
113 Posts |
Posted - 2007-06-15 : 15:27:53
|
| No it does not account for leap years or No there is nothing extra I do for leap years |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-06-15 : 15:41:43
|
sorry  it accounts for leap years just fine._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
csphard
Posting Yak Master
113 Posts |
Posted - 2007-06-15 : 16:03:50
|
| Thanks |
|
|
|
|
|
|
Datediff and leap years