- GC.Data
- GC.Pivot
- GC.Spread.Pivot
- GC.Spread.Slicers
- GC.Spread.CalcEngine
- GC.Spread.Commands
- GC.Spread.Common
- GC.Spread.Formatter
- GC.Spread.Report
- GC.Spread.Sheets
- GC.Spread.Sheets.IO
- GC.Spread.Sheets.AutoMerge
- GC.Spread.Sheets.Barcode
- GC.Spread.Sheets.Bindings
- GC.Spread.Sheets.CalcEngine
- GC.Spread.Sheets.Search
- GC.Spread.Sheets.CellState
- GC.Spread.Sheets.CellTypes
- GC.Spread.Sheets.Charts
- GC.Spread.Sheets.Commands
- GC.Spread.Sheets.Comments
- GC.Spread.Sheets.ConditionalFormatting
- GC.Spread.Sheets.ContextMenu
- GC.Spread.Sheets.DataValidation
- GC.Spread.Sheets.Fill
- GC.Spread.Sheets.Filter
- GC.Spread.Sheets.FloatingObjects
- GC.Spread.Sheets.FormulaTextBox
- GC.Spread.Sheets.FormulaPanel
- GC.Spread.Sheets.Hyperlink
- GC.Spread.Sheets.InputMask
- GC.Spread.Sheets.NameBox
- GC.Spread.Sheets.OutlineColumn
- GC.Spread.Sheets.Outlines
- GC.Spread.Sheets.PDF
- GC.Spread.Sheets.Print
- GC.Spread.Sheets.Shapes
- GC.Spread.Sheets.Slicers
- GC.Spread.Sheets.Sparklines
- GC.Spread.Sheets.StatusBar
- GC.Spread.Sheets.Tables
- GC.Spread.Sheets.TableSheet
- GC.Spread.Sheets.GanttSheet
- GC.Spread.Sheets.Touch
- GC.Spread.Sheets.Designer
- GC.Spread.Excel
GC.Pivot.PivotDateFilterOperator
Enumeration: PivotDateFilterOperator
GC.Pivot.PivotDateFilterOperator
Describe the type of date filter
Table of contents
Enumeration members
- Between
- M1
- M10
- M11
- M12
- M2
- M3
- M4
- M5
- M6
- M7
- M8
- M9
- Q1
- Q2
- Q3
- Q4
- after
- afterEqualsTo
- before
- beforeEqualsTo
- dateToDate
- equalsTo
- lastMonth
- lastQuarter
- lastWeek
- lastYear
- nextMonth
- nextQuarter
- nextWeek
- nextYear
- notBetween
- notEqualsTo
- thisMonth
- thisQuarter
- thisWeek
- thisYear
- today
- tomorrow
- yearToDate
- yesterday
Enumeration members
Between
• Between = 6
Indicates whether the date time is between the certain time.
M1
• M1 = 28
Indicates the January of a year.
M10
• M10 = 37
Indicates the October of a year.
M11
• M11 = 38
Indicates the November of a year.
M12
• M12 = 39
Indicates the December of a year.
M2
• M2 = 29
Indicates the February of a year.
M3
• M3 = 30
Indicates the March of a year.
M4
• M4 = 31
Indicates the April of a year.
M5
• M5 = 32
Indicates the May of a year.
M6
• M6 = 33
Indicates the June of a year.
M7
• M7 = 34
Indicates the July of a year.
M8
• M8 = 35
Indicates the August of a year.
M9
• M9 = 36
Indicates the September of a year.
Q1
• Q1 = 24
Indicates the first quarter of a year.
Q2
• Q2 = 25
Indicates the second quarter of a year.
Q3
• Q3 = 26
Indicates the third quarter of a year.
Q4
• Q4 = 27
Indicates the fourth quarter of a year.
after
• after = 4
Indicates whether the date time is after a certain time.
afterEqualsTo
• afterEqualsTo = 5
Indicates whether the date time is after or equal to a certain time.
before
• before = 2
Indicates whether the date time is before a certain time.
beforeEqualsTo
• beforeEqualsTo = 3
Indicates whether the date time is before or equal to a certain time.
dateToDate
• dateToDate = 41
Indicates the form customize start time to end time.
equalsTo
• equalsTo = 0
Indicates whether the date time is equal to a certain time.
lastMonth
• lastMonth = 13
Specifies last month.
lastQuarter
• lastQuarter = 20
Specifies last Quarter.
lastWeek
• lastWeek = 16
Specifies last week.
lastYear
• lastYear = 23
Specifies last Year.
nextMonth
• nextMonth = 14
Specifies next month.
nextQuarter
• nextQuarter = 18
Specifies next Quarter.
nextWeek
• nextWeek = 17
Specifies next week.
nextYear
• nextYear = 21
Specifies next Year.
notBetween
• notBetween = 7
Indicates whether the date time is not between the certain time.
notEqualsTo
• notEqualsTo = 1
Indicates whether the date time is not equal to a certain time.
thisMonth
• thisMonth = 12
Specifies this month.
thisQuarter
• thisQuarter = 19
Specifies this Quarter.
thisWeek
• thisWeek = 15
Specifies this week.
thisYear
• thisYear = 22
Specifies this Year.
today
• today = 8
Specifies today.
tomorrow
• tomorrow = 10
Specifies tomorrow.
yearToDate
• yearToDate = 40
Indicates the form Jan-1 to today in current year.
yesterday
• yesterday = 9
Specifies yesterday.