PivotFilter.WholeDayFilter Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Sets or gets the filtering semantics for date filters. Boolean (bool in C#). Read/Write

public:
 property bool WholeDayFilter { bool get(); void set(bool value); };

public bool WholeDayFilter { get; set; }

Public Property WholeDayFilter As Boolean

Property Value

Boolean

Remarks

The following describes the results for previous and current property settings:

False (Office 2010 behavior): Any time can be specified; dates are precise points in time (midnight of the specified date). Filtering date ranges start or end at midnight.
True (Office 2013 behavior): This behavior is enforced for Timeline controls. Only whole dates are specified; dates include all times-of-day until and not including the next day at midnight.

For a Timeline, always returns True; returns a run-time error when setting to this to False.

For a non-date filter, any access returns a run-time error.

Applies to