Excel.FilterDatetime interface

Represents how to filter a date when filtering on values.

[ API set: ExcelApi 1.2 ]

Properties

date

The date in ISO8601 format used to filter data.

[ API set: ExcelApi 1.2 ]

specificity

How specific the date should be used to keep data. For example, if the date is 2005-04-02 and the specifity is set to "month", the filter operation will keep all rows with a date in the month of april 2009.

[ API set: ExcelApi 1.2 ]

Property Details

date

The date in ISO8601 format used to filter data.

[ API set: ExcelApi 1.2 ]

date: string;
Property Value
string

specificity

How specific the date should be used to keep data. For example, if the date is 2005-04-02 and the specifity is set to "month", the filter operation will keep all rows with a date in the month of april 2009.

[ API set: ExcelApi 1.2 ]

specificity: Excel.FilterDatetimeSpecificity | "Year" | "Month" | "Day" | "Hour" | "Minute" | "Second";
Property Value
Excel.FilterDatetimeSpecificity | "Year" | "Month" | "Day" | "Hour" | "Minute" | "Second"