From: rodchar on
Hey All,

select datediff(wk,'1/10/2010','12/9/2009')

This to me should be 6 instead of 5. I've tried the SET DateFirst but they
all resolve to 5. Am I looking at this all wrong?

thanks,
rodchar
From: rodchar on
scratch this one too. not my day...

"rodchar" wrote:

> Hey All,
>
> select datediff(wk,'1/10/2010','12/9/2009')
>
> This to me should be 6 instead of 5. I've tried the SET DateFirst but they
> all resolve to 5. Am I looking at this all wrong?
>
> thanks,
> rodchar
From: sloan on
How about posting what you found, so future googlers (errr bingers) find a
solution and not just a dead-end thread?

...
"rodchar" <rodchar(a)discussions.microsoft.com> wrote in message
news:0D38C98A-C94C-4339-8B60-368CFEDE02CB(a)microsoft.com...
> scratch this one too. not my day...
>
> "rodchar" wrote:
>
>> Hey All,
>>
>> select datediff(wk,'1/10/2010','12/9/2009')
>>
>> This to me should be 6 instead of 5. I've tried the SET DateFirst but
>> they
>> all resolve to 5. Am I looking at this all wrong?
>>
>> thanks,
>> rodchar


From: rodchar on
user error.

"sloan" wrote:

> How about posting what you found, so future googlers (errr bingers) find a
> solution and not just a dead-end thread?
>
> ...
> "rodchar" <rodchar(a)discussions.microsoft.com> wrote in message
> news:0D38C98A-C94C-4339-8B60-368CFEDE02CB(a)microsoft.com...
> > scratch this one too. not my day...
> >
> > "rodchar" wrote:
> >
> >> Hey All,
> >>
> >> select datediff(wk,'1/10/2010','12/9/2009')
> >>
> >> This to me should be 6 instead of 5. I've tried the SET DateFirst but
> >> they
> >> all resolve to 5. Am I looking at this all wrong?
> >>
> >> thanks,
> >> rodchar
>
>
> .
>