Edit

Share via

PivotFilter.WholeDayFilter property (Excel)

  • Article

Sets or gets the filtering semantics for date filters. Read/write Boolean.

Syntax

expression.WholeDayFilter

expression A variable that represents a PivotFilter object.

Remarks

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

  • False (Microsoft 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 (Microsoft 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 this to False.

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

Property value

BOOL

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.