Excel.FilterDatetime interface

Package:

excel

Represents how to filter a date when filtering on values.

Remarks

[ API set: ExcelApi 1.2 ]

Properties

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

Property Details

date

The date in ISO8601 format used to filter data.

date: string;

Property Value

string

Remarks

[ 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 specificity is set to "month", the filter operation will keep all rows with a date in the month of April 2005.

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

Property Value

Excel.FilterDatetimeSpecificity | "Year" | "Month" | "Day" | "Hour" | "Minute" | "Second"

Remarks

[ API set: ExcelApi 1.2 ]