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(yyyyOrderDate) = 'Dropdown1.SelectedText' DATEPART(mmOrderDate) = '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.