PivotFilter.WholeDayFilter property (Excel)
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.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for