D-SQL (9/13/2012)
Ill try this out. I copy pasted the script not the one you updated they are both the same except the where clause. The reason they needed dbo.tblLoan.Expected_Close = 9).Is because some instances the loan is in progress and has for example the expected close month of 8 but actually doesnt close till the 1st or 2nd day in september they want to count that as previous month. I guess they have a period of 1-5 days each month that could count as previous if it was started inthe prior month this is why they use the expected close. Hope that answers your question. Once again thanks for your help much appreciated
Nope, doesn't help as it provides me no information I can use to really determine how to calculate the value for Expected_Close based on the current date.