-
Notifications
You must be signed in to change notification settings - Fork 62
/
excel.filterdatetime.yml
39 lines (39 loc) · 1.56 KB
/
excel.filterdatetime.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
### YamlMime:TSType
name: Excel.FilterDatetime
uid: 'excel!Excel.FilterDatetime:interface'
package: excel!
fullName: Excel.FilterDatetime
summary: Represents how to filter a date when filtering on values.
remarks: '\[ [API set: ExcelApi 1.2](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
type: interface
properties:
- name: date
uid: 'excel!Excel.FilterDatetime#date:member'
package: excel!
fullName: date
summary: The date in ISO8601 format used to filter data.
remarks: '\[ [API set: ExcelApi 1.2](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'date: string;'
return:
type: string
- name: specificity
uid: 'excel!Excel.FilterDatetime#specificity:member'
package: excel!
fullName: specificity
summary: >-
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.
remarks: '\[ [API set: ExcelApi 1.2](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'specificity: Excel.FilterDatetimeSpecificity | "Year" | "Month" | "Day" | "Hour" | "Minute" | "Second";'
return:
type: >-
<xref uid="excel!Excel.FilterDatetimeSpecificity:enum" /> | "Year" | "Month" | "Day" | "Hour" | "Minute" |
"Second"