It may be a permissions issue... whoever you're logged in as may not have permissions to see '\\Servar2\test\xx.bak'.  Try pasting that UNC into Windows Explorer (then hit CR, of course). ...

Thought I'd throw a different slant at this one because it's an "open ended" report with no definite constraints on how many reporting periods may be requested within the start...

Sorry folks... I had posted some code and there was an error in it because the date part for weeks is acting very odd... trying to see what's up with...

Looking at it now...

Robert,

In my haste, I missed the SPID thing.  Clever to say the least.  Thanks for the feedback.

If you run Serqiy's method, you can let it "crawl" all day... it will not interfere with normal daily processes...

There is another problem with Wrack's function, as well... it returns the date as an Integer... if you want to compare the date it returns to a DATETIME column, you...

I'm thinking that just a little irresponsible on your part.  Good night, Lynn.

I agree that good teachers work themselves out of a job with their students... the point is that you misread the question and provided an incorrect answer.  Thank you for...

Good teachers are always responsible for the outcome...

Folks, go back and read Vladan's post... that's the only correct way to do it.  He explains "why" quite nicely, too.

Careful... that, too, will likely cause a table scan because the column in the WHERE clause is contained in a formula...

Well, when folks post such detailed information about how their code works (very nice job, by the way), others take the code and just use it instead of analyzing it. ...

Sure, that's what he said he thought the logic should be... he said immediately after that...

"Is the logic correct?  Can someone please help me decipher...

Thought this was what he asked for...

"certain action items need to be automatically assigned (through code) a due date on 3 Wednesday’s from whatever today is.  "

I agree, the 14...