2.5.12 CFDateOper
The CFDateOper enumeration specifies the valid types of date comparisons used in conditional formatting rules. All of these comparisons evaluate to False (0) if the cell does not contain a date.
The value of this enumeration MUST be a value from the following table.
|
Name |
Value |
Meaning |
|---|---|---|
|
0x00000000 |
This rule evaluates to True (1) when the date specified by the cell is today's date. |
|
|
0x00000001 |
This rule evaluates to True (1) when the date specified by the cell is yesterday's date. |
|
|
0x00000002 |
This rule evaluates to True (1) when the date specified by the cell is today's date or a day up to six days prior to today's date. |
|
|
0x00000003 |
This rule evaluates to True (1) when the date specified by the cell is a day in the one-week period beginning with the previous Sunday. |
|
|
0x00000004 |
This rule evaluates to True (1) when the date specified by the cell is a day in the one-week period ending with the previous Saturday. |
|
|
0x00000005 |
This rule evaluates to True (1) when the date specified by the cell is a day in the previous month. |
|
|
0x00000006 |
This rule evaluates to True (1) when the date specified by the cell is tomorrow's date. |
|
|
0x00000007 |
This rule evaluates to True (1) when the date specified by the cell is a day in the one-week period beginning with the next Sunday. |
|
|
0x00000008 |
This rule evaluates to True (1) when the date specified by the cell is a day in the next month. |
|
|
0x00000009 |
This rule evaluates to True (1) when the date specified by the cell is a day in the current month. |