Compare month with date in data table select method.

[Kinzz Patel]

Hi.,

in Data table. data fill like

Admission # Attendance Status Attendance Date
1 Present 09/30/2011
2 Present 09/30/2011
3 Present 08/30/2011
4 Absent 09/29/2011
5 Present 10/30/2011
6 Leave 09/20/2011

from this i want to check condition like

Select AdmissionNumber,AttendanceStatus,AttendanceDate
from Datatable
Where Month(AttendanceDate) = 8


so i this data i want to fetch.

Admission # Attendance Status Attendance Date
3 Present 08/30/2011

i used like dt.Select("Month(AttendanceDate) = 8")
also used DatePart and DateName function but it's not work.



please send me syntax or function.