ApplyRelativeDateRangeFilter Method (WorksheetFilterSettings)

'Declaration
 
Public Function ApplyRelativeDateRangeFilter( _
   ByVal relativeColumnIndex As Integer, _
   ByVal offset As RelativeDateRangeOffset, _
   ByVal duration As RelativeDateRangeDuration _
) As RelativeDateRangeFilter

public RelativeDateRangeFilter ApplyRelativeDateRangeFilter( 
   int relativeColumnIndex,
   RelativeDateRangeOffset offset,
   RelativeDateRangeDuration duration
)

Parameters

relativeColumnIndex

A zero based column index relative to the Region

offset

The offset of relative filter. This combined with the duration determines the full range of accepted dates.

duration

The duration of the full range of accepted dates.

The RelativeDateRangeFilter allows you to filter in dates which are in the previous, current, or next time period relative to the date when the filter was applied. The time periods available are day, week, month, quarter, year. So when using the previous filter type with a day duration, a 'yesterday' filter is created. Or when using a current filter type with a year duration, a 'this year' filter is created. However, these filters compare the data against the date when the filter was created. So a 'this year' filter created in 1999 will filter in all cells containing dates in 1999, even if the workbook is opened in 2012.

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

WorksheetFilterSettings Class
WorksheetFilterSettings Members
RelativeDateRangeFilter Class
GetFilter Method
ClearFilter Method