7-2013(datetime) checking

Question

The 3 type field displasy ,any schme display ,but The any loan creating one scheme select ,the scheme select dissuedate creating and partiqular duedate creating...... scheme A select loan creating (set perioddays 250)(scheme B is period days 100) .The any type scheme select the combobox and one year closing people display the query


example:     ********Alter PROCEDURE sp_fillng                      
(                       
 @vScheme varchar (50), 
@vStatus varchar(50)  
                   
)                      
AS                       
 begin                          
                       
      
       
select  vLoan_No as LoanNumber,vParty_Id as CustomerName ,dIssue_Date as DissueDate,dcLoan_Amt as LoanAmount from tbl_LoanMaster              
             
WHERE vScheme =@vScheme and                        ?                       and vStatus='N'   
********************************************************************


vScheme
********
MONTHLY
Monthly
Monthly
SCHEME A
SCHEME B
Monthly
SCHEME A
Monthly
Monthly
SCHEME A
SCHEME A
SCHEME A
SCHEME A
SCHEME A

dissue date
***********

13-Feb-13 12:15:38 PM
13-Feb-13 2:26:25 PM
13-Feb-13 3:05:06 PM
14-Feb-13 10:45:43 AM
14-Feb-13 11:56:27 AM
14-Feb-13 12:58:03 PM
20-Feb-13 11:43:27 AM
19-Feb-13 11:43:27 AM
01-Jan-13 11:48:38 AM
01-Jan-13 3:17:08 PM
21-Feb-13 4:52:49 PM
22-Feb-13 6:22:33 PM
23-Feb-13 2:11:44 PM
23-Feb-13 2:28:00 PM

due date
***********

13-Feb-13 12:15:38 PM
13-Feb-13 2:26:25 PM
13-Feb-13 3:05:06 PM
14-Feb-13 10:45:43 AM
18-Feb-13 11:56:27 AM
14-Feb-13 12:58:03 PM
20-May-13 11:43:27 AM
20-Mar-13 11:43:27 AM
21-Feb-13 11:48:38 AM
21-Feb-13 3:17:08 PM
21-Feb-14 4:52:49 PM
22-Feb-14 6:22:33 PM
23-Feb-14 2:11:44 PM
23-Feb-14 2:28:00 PM
23-Feb-14 2:32:02 PM
26-Feb-14 3:58:05 PM
26-Feb-14 4:03:39 PM