JAYESH AJ

JAYESH AJ

  • NA
  • 97
  • 29.9k

current date display details

Sep 10 2013 6:08 AM
    select vLoan_No as LoanNumber,dIssue_Date as Date,vParty_Id as CustomerName,dcLoan_Amt as LoanAmount, dDue_Date as DueDate from tbl_LoanMaster 
 WHERE dIssue_Date BETWEEN   
 convert(varchar,@dtFrom,101) and convert(varchar,@DtTo,101)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?


Answers (3)