xlFilterAllDatesInPeriod

Specifies how dates should be filtered in the specified period.

xlFilterAllDatesInPeriodDayFilter all dates for the specified date (2)
xlFilterAllDatesInPeriodHourFilter all dates for the specified hour (3)
xlFilterAllDatesInPeriodMinuteFilter all dates until the specified minute (4)
xlFilterAllDatesInPeriodMonthFilter all dates for the specified month (1)
xlFilterAllDatesInPeriodSecondFilter all dates until the specified second (5)
xlFilterAllDatesInPeriodYearFilter all dates for the specified year (0)

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

REMARKS
* Added in 2007.

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top