current date display details

Question

select vLoan_No as LoanNumberdIssue_Date as DatevParty_Id as CustomerNamedcLoan_Amt as LoanAmount dDue_Date as DueDate from tbl_LoanMaster WHERE dIssue_Date BETWEEN convert(varchar@dtFrom101) and convert(varchar@DtTo101)and vStatus='N' dtfrom= 9-92013 and DtTo=10-9-2013 ans corect>>>>>> But dtfrom= 9-92013 and DtTo=9-9-2013 (how can query creating curent checking how?

JAYESH AJ · Answer

select vLoan_No as LoanNumberdIssue_Date as DatevParty_Id as CustomerNamedcLoan_Amt as LoanAmount dDue_Date as DueDate from tbl_LoanMaster WHERE dIssue_Date > = '25-jul-2013' and dIssue_Date -- Date >= '9-9-2013' and Date display the Loan NdateCustNmae ........ value not display ******************************************** CREATE PROCEDURE ln_DailyIssueReport ??????????? orginal type -- Add the parameters for the stored procedure here ( @dtFrom datetime @DtTo datetime ) AS BEGIN SET NOCOUNT ON; select vLoan_No as LoanNumberdIssue_Date as DatevParty_Id as CustomerNamedcLoan_Amt as LoanAmount dDue_Date as DueDate from tbl_LoanMaster WHERE dIssue_Date BETWEEN convert(varchar'25-jul-2013'101) and convert(varchar'25-jul-2013'101)and vStatus='N'

Suthish Nair · Answer

Try like this and Date >= '9-9-2013' and Date <= '9-9-2013'

JAYESH AJ · Answer

pls ans sir