PivotFilter.UseWholeDay Property

Gets or sets whether the date filter should use whole days in its filtering criteria.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v20.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

NuGet Packages: DevExpress.Spreadsheet.Core, DevExpress.WindowsDesktop.Spreadsheet.Core

Declaration

C#

bool UseWholeDay { get; set; }

VB.NET

Property UseWholeDay As Boolean

Property Value

Type	Description
Boolean	true, to use whole days in the date filter; otherwise,false.

Remarks

Enable the UseWholeDay property to ignore time values in date and time fields when using a date filter.

Note

The UseWholeDay property is always true when a PivotTable timeline is used to filter dates. If you change the property’s value to false in this case, the Spreadsheet throws an InvalidOperationException.