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

Question

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 VkiznosbezDDVDenVaznost from Dogovor where Datadog=?; oleDbAd2.SelectCommand.Parameters.Add(@Datadog DateTime.Now.Year ); //I don't know how to write thic line Thanks in advance.

Vulpes · Answer

Try: oleDbAd2.SelectCommand.CommandText = SELECT Brdog Datadog Bravtobusi VkiznosbezDDVDenVaznost 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 :)

Nel · Answer

Thank you:)

Pravin Ghadge · Answer

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