# GrapeCity.Documents.Excel.PivotFieldDateGroupBy

## Content

<div class="doc-site-dotnet-api-container">




  <h1 id="GrapeCity_Documents_Excel_PivotFieldDateGroupBy" data-uid="GrapeCity.Documents.Excel.PivotFieldDateGroupBy" class="text-break">PivotFieldDateGroupBy Enum
</h1>
  <div class="markdown level0 summary"><p>Specifies date and time units that can be used to group a PivotField.</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <h6><strong>Namespace</strong>: <a class="xref" href="GrapeCity.Documents.Excel.html">GrapeCity.Documents.Excel</a></h6>
  <h6><strong>Assembly</strong>: DS.Documents.Excel.dll</h6>
  <h5 id="GrapeCity_Documents_Excel_PivotFieldDateGroupBy_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">[Flags]
public enum PivotFieldDateGroupBy</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">&lt;Flags&gt;
Public Enum PivotFieldDateGroupBy</code></pre>
  </div>
  <h5 id="GrapeCity_Documents_Excel_PivotFieldDateGroupBy_examples"><strong>Examples</strong></h5>
  <pre><code class="lang-csharp">PivotFieldDateGroupOptions options = new PivotFieldDateGroupOptions();
options.GroupBy = PivotFieldDateGroupBy.Months | PivotFieldDateGroupBy.Years;
PivotFieldDateGroupBy groupBy = options.GroupBy;</code></pre>

  <h3 id="fields">Fields
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    <thead>
    </thead></thead><tbody>
      <tr>
        <td id="GrapeCity_Documents_Excel_PivotFieldDateGroupBy_Days">Days</td>
        <td><p>Group by days. The group size is controlled by <a class="xref" href="GrapeCity.Documents.Excel.PivotFieldDateGroupOptions.Days.html#GrapeCity_Documents_Excel_PivotFieldDateGroupOptions_Days">Days</a>.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_PivotFieldDateGroupBy_Hours">Hours</td>
        <td><p>Group by hours.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_PivotFieldDateGroupBy_Minutes">Minutes</td>
        <td><p>Group by minutes.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_PivotFieldDateGroupBy_Months">Months</td>
        <td><p>Group by months.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_PivotFieldDateGroupBy_Quarters">Quarters</td>
        <td><p>Group by quarters.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_PivotFieldDateGroupBy_Seconds">Seconds</td>
        <td><p>Group by seconds.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_PivotFieldDateGroupBy_Years">Years</td>
        <td><p>Group by years.</p>
</td>
      </tr>
    </tbody>
  </table>
</div>