SQL Junkie,

I had this same problem and found your solution.

Your code worked perfectly. I wish I knew why the Sort Order in SSRS 2000 isn't working, though. IN any...

OK, what's the solution? XP SP2...

yes I am. I forgot to include that in my post.

BINGO! That did it. Thanks. That was driving me crazy!

Mike

2000

This is a great discussion. Thanks for the info.

I agree with the premise that putting all of my problems into a bigger, faster problem box isn't going to help...

Please post your code and select statement

Sorry I don't have an answer to your problem, I was searching for a solution to my own similar problem and found your post. You might try switching to Windows/SQL...

Michael (and all)

Thanks to everyone for the replies. What a great learning (and teaching) tool web forums can be.

The great comedian/pianist Victor Borge said once, "It's YOUR language, I'm just...

Ken,

That seems to work. Now off to BooksOnline to figure out what you did.

Thanks

Mike

David,

Thanks for the reply. Sorry if my answer is obtuse, but I'm more experienced at front-end programming...in the WHERE clause, if NEWREQDATE = 000000000 THEN do the DATEDIFF on ORIGREQDATE,...

John Rowan,

Thanks for that...I forgot about the decimal type. Too bad it returns 0 instead of 0.00. I can handle that in code, though

Farrell,

Yeah, just a display issue....

Bimal, your function worked like a charm. Thanks for the help!