i need to display records in data grid based on the from and to dates....but i have only records createddate column in my table in the data base
What I have tried:
ALTER PROCEDURE [dbo].[SP_PURCHASE]
(
@MODE INT,
@CRDATE DATETIME = NULL,
@FDATE DATETIME =NULL,
@TODATE DATETIME=NULL
)
AS
DECLARE @RESULT INT
SET @RESULT=0
ELSE IF @MODE = 6
BEGIN
select * from TR_PURCHASE WHERE
CRDATE BETWEEN ' + ''''+ CONVERT(VARCHAR(3),DATEPART(MM,@FDATE))+'/'+
CONVERT(VARCHAR(3),DATEPART(DD,@FDATE))+'/'+
CONVERT(VARCHAR(4),DATEPART(YYYY,@FDATE)) + ''''+
' AND ' + ''''+CONVERT(VARCHAR(3),DATEPART(MM,@TODATE))+'/'+
CONVERT(VARCHAR(3),DATEPART(DD,@TODATE))+'/'+
CONVERT(VARCHAR(4),DATEPART(YYYY,@TODATE))+''' AND BCODE=+ '''' +CONVERT(VARCHAR(15),@BCODE)+'''';
end
IF @@ROWCOUNT > 0
SET @RESULT = 1