Hey Jeff, I sorted this out, but thanks for your reply. I'll keep that in mind next time.

I got it working, I basically put a Where Clause ColName >= GetDate()

Thanks for all your replies.

Thanks guys, I solved this yesterday by putting the decimal value outside the function as specified. It worked for me, thanks for all the input.

yup that sounds right.

to count days as half or full. for example if you do a datediff between two dates, it counts the difference but it doesn't count the date you start the...

exactly, which would make the result 0. To that 0 I want to add 0.5, which would make the result 0.5.

I understand this, I guess I just wasn't being clear. Maybe if I illustrate a scenario that would explain it better:

____________________________________________________________________________________

StartDate ...

thanks for your response, but I need it to return a 0.5 instead of 1 hence the CASE. But I figured that the datediff only can return int values, so...

yes I know I am not doing a join over there. I have a calendar table with all the dates specified. But I figured I might be able to get...

Hey guys,

this gives me the interval excluding weekends, I was wondering instead of doing a join, is there a way I could exclude specific dates in this query?:

SET...