如何获取基于月份的sharepoint列表项计数

using Microsoft.SharePoint.Client;
using System;

class Program
{
    static void Main()
    {
        string siteUrl = "https://your-sharepoint-site-url";
        string listTitle = "Your List Title";
        DateTime startDate = new DateTime(2022, 1, 1);
        DateTime endDate = new DateTime(2022, 12, 31);

        using (ClientContext context = new ClientContext(siteUrl))
        {
            List list = context.Web.Lists.GetByTitle(listTitle);

            CamlQuery query = new CamlQuery();
            query.ViewXml = $@"
                <View>
                    <Query>
                        <Where>
                            <And>
                                <Geq>
                                    <FieldRef Name='DateField' />
                                    <Value IncludeTimeValue='FALSE' Type='DateTime'>{startDate.ToString("yyyy-MM-ddTHH:mm:ssZ")}</Value>
                                </Geq>
                                <Leq>
                                    <FieldRef Name='DateField' />
                                    <Value IncludeTimeValue='FALSE' Type='DateTime'>{endDate.ToString("yyyy-MM-ddTHH:mm:ssZ")}</Value>
                                </Leq>
                            </And>
                        </Where>
                    </Query>
                </View>";

            ListItemCollection items = list.GetItems(query);
            context.Load(items);
            context.ExecuteQuery();

            int itemCount = items.Count;
            Console.WriteLine($"基于月份的列表项计数：{itemCount}");
        }
    }
}