DECLARE @FirstDay   DATETIME,@LastDay DATETIME
SET     @FirstDay =(SELECT DATEADD(MONTH,DATEDIFF(MONTH,0,GETDATE())-0,0  ))
SET		@LastDay  =(SELECT DATEADD(MONTH,DATEDIFF(MONTH,-1,GETDATE())-0,-1))
SELECT 
	 Loanreference
	,BranchCode
	,Firstdisbursementdate    
    ,LoanOfficerCode
	,[#ofLoans]
	,LoanId
	,IDNumber
	,ClientNumber
    ,StartDate
    ,CreationDate
    ,CreatedBy 
FROM 
	dbo.tbSales
WHERE Case When ISDATE(Firstdisbursementdate) = 1
        Then CONVERT(DATETIME,Firstdisbursementdate,120)
        Else Cast(0 as datetime) End
    BETWEEN @FirstDay AND @LastDay

select  distinct Firstdisbursementdate
 from tbSales
 where Len(Firstdisbursementdate) > 8