Excel.FilterDatetime interface
Represents how to filter a date when filtering on values.
Remarks
Used by
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
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"