***************
select from and to date button click
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Iftikar HussainPosted Jul 25, 2013, 7:51 AM
Alter PROCEDURE sp_LoanReg
(
@dIssue_Date datetime,
@dDue_Date datetime
@DateFo datetime,
@DateToo datetime
)
AS
begin
select vLoan_No As LoanNumaber,dIssue_Date As Date,vScheme As CustomerName,dIssue_Date,dDue_Date from tbl_LoanMaster
--
WHERE dIssue_Date>= @DateFo and dDue_Date <=@DateToo
end
Regards,
Iftikar
JAYESH AJPosted Jul 25, 2013, 7:47 AM
JAYESH AJPosted Jul 25, 2013, 7:20 AM
(
@dIssue_Date datetime,
@dDue_Date datetime
@DateFo datetime,
@DateToo datetime
)
AS
begin
select vLoan_No As LoanNumaber,dIssue_Date As Date,vScheme As CustomerName,dIssue_Date,dDue_Date from tbl_LoanMaster
--
WHERE @dIssue_Date= @DateFo and @dDue_Date=@DateToo
-- WHERE dIssue_Date= '2012-02-20 00:00:00' and dDue_Date='2013-05-20 00:00:00'
-- WHERE dIssue_Date= @dIssue_Date and dDue_Date=@dDue_Date
end
Riyaz AkhtarPosted Jul 25, 2013, 3:07 AM
Iftikar HussainPosted Jul 25, 2013, 2:45 AM
Please provide more details
Regards,
Iftikar