2
Answers

How to retrives only years from date time picker

Photo of chan li chin

chan li chin

15y
6.5k
1
 sql = "SELECT DATEPART("yyyy",dates) FROM summary WHERE plants = '" & yieldsummary.cbPlant.Text & "'"
Hi, I am now want to retrieve only year from my table(summary),field name(dates). So i am facing the problem on how to display the year in combo Box. my sql statement as above. the error disply"No value given for one or more required parameters"Thanks

Answers (2)