Sql Select To Include Date?

I have a table of parts and want to display some statistics from it.  The parts table has several fields in it, but the two that I need to use in my sql select queries are "PartUserID" and "DateUseBy", but I don't know how to use the "dateuseby" in the second example.

Can someone help me out with #2?

1. Display the total number of parts owned by a user:
SQL Query:
        SelectCommand="SELECT COUNT (*) FROM [ZCPart] WHERE (ZCPart.PartUserId = @PartUserId)"
        OnSelecting="sqlPartCount_Selecting">
        <SelectParameters>
            <asp:Parameter Name="PartUserID" />
        </SelectParameters>
Code-behind:
    protected void sqlPartCount_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
    {
        e.Command.Parameters["@PartUserID"].Value = Membership.GetUser().ProviderUserKey;
    }
   
2. Display the total number of parts owned by a user that are to be used in the current year. The table has a field "dateuseby" that should be used for the "Where" but I don't know how to get it.
SQL Query:
How to I include the "usebydate" so that it will use 2008 as the year ? I wrote the following query as an example of what I'm trying to get.

        SelectCommand="SELECT COUNT (*) FROM [ZCPart] WHERE (ZCPart.PartUserId = @PartUserId, ZCPart.DateUseById = @PartUseById)"
        onselecting="sqlPartYearCount_Selecting">
        <SelectParameters>
            <asp:Parameter Name="PartUserID" />
            <asp:Parameter Name="DateUseByID" />
        </SelectParameters>

Code-behind:
    protected void sqlPartYearCount_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
    {
        e.Command.Parameters["@PartUserID"].Value = Membership.GetUser().ProviderUserKey;
       
        // ? How do I change the date in the field to be in "2008" format and then put that in the sql query?
        //e.Command.Parameters["@DateUseByID"].Value = currentYear;
        //currentYear currentDateTime = DateTime.Now;
    }