Seach for Date from database using Asp.Net

Question

HI,

 

Can any one explain about the date format 

for example i have  a text box with submit button when i enter date its not displaying the data from database when i enter only year  it display the data related to the date is displayed ,can any one explain me the data validation and search for date with sample example