XlFilterAllDatesInPeriod Enumeration

Specifies how dates should be filtered in the specified period.

Version Information
 Version Added:  Excel 2007

Name Value Description
xlFilterAllDatesInPeriodDay 2 Filter all dates for the specified date.
xlFilterAllDatesInPeriodHour 3 Filter all dates for the specified hour.
xlFilterAllDatesInPeriodMinute 4 Filter all dates until the specified minute.
xlFilterAllDatesInPeriodMonth 1 Filter all dates for the specified month.
xlFilterAllDatesInPeriodSecond 5 Filter all dates until the specified second.
xlFilterAllDatesInPeriodYear 0 Filter all dates for the specified year.