Share via

2.2.5.4.8.1.2 Date Filters

  • Article

A date filter specifies a criterion that is applied to date type pivot items (section 2.2.5.4.4) of a pivot field (section 2.2.5.4.3). A date filter determines which pivot items (section 2.2.5.4.4) are included in the calculation of the PivotTable view (section 2.2.5.4) and are displayed in the PivotTable view (section 2.2.5.4) report.

Date filters are specified by SXAddl_SXCSXFilter12_SXDSXFilter records (section 2.4.273.82) with the sxft field in the range from 0x0000001A through 0x00000041.

For non-OLAP PivotTable views (section 2.2.5.4.2), a date filter can be applied if and only if the SXFDB record (section 2.4.283) associated with the corresponding pivot field (section 2.2.5.4.3) has the fDateInField field equal to 0x1, and the fNonDates field is equal to 0. For OLAP PivotTable views (section 2.2.5.4.2), a date filter can be applied if the fTimeHierarchy field of the SXTH record (section 2.4.308) that specifies the pivot hierarchy (section 2.2.5.4.5) is equal to 1.

Date filters are applied before value filters (section 2.2.5.4.8.1.3) and in no specific order.