How to search using parsial date

Question

i want to search using separate date like here   bulan means month ,Tahun means Year , if you have solution please tell me and I 'll appreciate it

Manas Mohapatra · Answer

I am not sure what you are displaying in dropdown values. Still providing som solutions:   When you are loading values to dropdown load year and month to dropdown values respectively.  Means for year(bulan): Text is displaying  Semua Bulan but back end value will be 2014. And this value will be use in query.   SELECT * FROM TableName WHERE  DATEPART(yyyy,OrderDate) = '"Dropdown1.SelectedText"', DATEPART(mm,OrderDate) = '"Dropdown2.SelectedText"';   If it doesn't resolve your problem please provide what you are displaying in dropdown and backend values of dropdown. Attach some screenshot.