stored proce help needed

hi experts

i have small problem in the following procedure
If i execute following
exec DBSP_GetTermAndCondition '','','','','','04/04/2011','04/04/2011'  i dont get the records created on 04/04/04 ..what could be the problem
 but while populating table   select * from dbo.TBL_TermAndCondition   the result exists




--exec DBSP_GetTermAndCondition '','','','','','04/04/2011','04/04/2011'
       
ALTER PROCEDURE [dbo].[DBSP_GetTermAndCondition]          
(            
@TermDescription VARCHAR(200) = '',          
@TermDefault BIT,            
@TermStatus INT,          
@LastUpdatedBy INT,        
@DivisionID varchar(200)='',    
@LastUpdatedFrom DateTime = null,    
@LastUpdatedTo DateTime=null    
 )            
AS          
BEGIN            
DECLARE @SQL VARCHAR(8000)
DECLARE @TEMP VARCHAR(200)            
           
           
SET @SQL = '        
SELECT DISTINCT T.TermID, T.TermDescription, T.StatusID, S.StatusDescription, T.TermDefault,          
u.UserFirstName + '+ ''' '''+ ' + u.UserLastName as CreatedBy, T.CreatedDate,    
ur.UserFirstName + '+ ''' '''+ '+ u.UserLastName as LastUpdatedBy,T.LastUpdatedDate, dbo.fneBid_TermDivision(T.TermID) DivisionName      
FROM TBL_TermAndCondition AS T              
left join TBL_eBid_Status S on T.StatusID = S.StatusID        
left join TBL_TermAndConditionDivision tcd on T.TermID = tcd.TermID      
left join TBL_Division d on tcd.DivisionID = d.DivisionID      
left join TBL_eBid_User u  on T.createdby=u.userid        
left join TBL_eBid_User ur on T.LastUpdatedBy=ur.userid                
Where T.TermID > 0 '            
     
IF(@TermDescription <> '')
 BEGIN          
   SET @SQL = @SQL + ' and TermDescription like ' + '''' + '%' + @TermDescription + '%'  + ''''          
 END            
           
IF(@TermDefault = 1 )
 BEGIN            
   SET @SQL =  @SQL + ' and TermDefault =  '+ convert(varchar(5), @TermDefault)
 END
           
IF(@TermStatus != 0)
 BEGIN
   SET @SQL =  @SQL + ' and T.StatusID =  '+ convert(varchar(10),@TermStatus )            
 END          
           
IF(@LastUpdatedBy > 0)            
 BEGIN          
   SET @SQL =  @SQL + ' and T.LastUpdatedBy =  ' + convert(varchar(5),@LastUpdatedBy )            
 END        
       
IF(@DivisionID <> 0)        
BEGIN          
   SET @SQL = @SQL + ' and d.DivisionID like ' + '''' + '%' + @DivisionID + '%'  + ''''          
END    

IF (@LastUpdatedFrom < @LastUpdatedTo)
     
        BEGIN
          SET @SQL = @SQL + ' AND CONVERT(varchar,isnull(t.LastUpdatedDate,'''+CONVERT(VARCHAR(30),@LastUpdatedFrom,112) + '''),112) >=''' + CONVERT(VARCHAR(30),@LastUpdatedFrom,112) + ''''
          SET @SQL = @SQL + ' AND CONVERT(varchar,isnull(t.LastUpdatedDate,'''+CONVERT(VARCHAR(30),@LastUpdatedTo,112) + '''),112) <= ''' + CONVERT(VARCHAR(30),@LastUpdatedTo,112) + ''''
        END
          ELSE IF (@LastUpdatedFrom = @LastUpdatedTo)
        BEGIN
       
          SET @SQL = @SQL + ' AND CONVERT(varchar,t.createdDate,112) = ''' + CONVERT(VARCHAR(30),@LastUpdatedFrom,112) + ''''
          SET @SQL = @SQL + ' AND CONVERT(varchar,t.LastUpdatedDate,112) = ''' + CONVERT(VARCHAR(30),@LastUpdatedTo,112) + ''''
          END
       
             ELSE IF (@LastUpdatedFrom = NULL)
          BEGIN
              SET @SQL = @SQL + ' AND CONVERT(varchar,t.CreatedDate,112) >=''' + CONVERT(VARCHAR(30),@LastUpdatedFrom,112) + ''''
          SET @SQL = @SQL + ' AND CONVERT(varchar,t.LastUpdatedDate,112) <= ''' + CONVERT(VARCHAR(30),@LastUpdatedTo,112) + ''''
          END
   END

PRINT @SQL
EXEC (@SQL)