How to select only those rows from access database table with date from the current year

Hello,

Can anybody help me please how to select only those rows from the table which have current yera for date.year?

oleDbAd2.SelectCommand.CommandText = "SELECT Brdog, Datadog, Bravtobusi, VkiznosbezDDVDen,Vaznost from Dogovor where Datadog=?";
 
  oleDbAd2.SelectCommand.Parameters.Add("@Datadog", DateTime.Now.Year ); //I don't know how to write thic line

Thanks in advance.

hi,

oleDbAd2.SelectCommand.CommandText = "SELECT Brdog, Datadog, Bravtobusi, VkiznosbezDDVDen,Vaznost from Dogovor where Year(Datadog)=?";
 
  oleDbAd2.SelectCommand.Parameters.Add("@Datadog", DateTime.Now.Year ); //I

Try:

oleDbAd2.SelectCommand.CommandText = "SELECT Brdog, Datadog, Bravtobusi, VkiznosbezDDVDen,Vaznost from Dogovor where Year(Datadog) = ?";

oleDbAd2.SelectCommand.Parameters.Add("@Datadog", OleDbType.Int).Value = DateTime.Now.Year; 

EDIT: Pravin beat me to it - but basically same answer :)

Thank you:)