[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
ST_TimePeriod (Time Period Types)
Used in a "contains dates" conditional formatting rule. These are dynamic time periods, which change based on the date the conditional formatting is refreshed / applied.
This simple type's contents are a restriction of the XML Schema string datatype.
The following are possible enumeration values for this type:
|
Enumeration Value |
Description |
|
last7Days (Last 7 Days) |
A date in the last seven days. |
|
lastMonth (Last Month) |
A date occuring in the last calendar month. |
|
lastWeek (Last Week) |
A date occuring last week. |
|
nextMonth (Next Month) |
A date occuring in the next calendar month. |
|
nextWeek (Next Week) |
A date occuring next week. |
|
thisMonth (This Month) |
A date occuring in this calendar month. |
|
thisWeek (This Week) |
A date occuring this week. |
|
today (Today) |
Today's date. |
|
tomorrow (Tomorrow) |
Tomorrow's date. |
|
yesterday (Yesterday) |
Yesterday's date. |
|
Referenced By |
|
cfRule@timePeriod (§3.3.1.9) |
The following XML Schema fragment defines the contents of this simple type:
<simpleType name="ST_TimePeriod">
<restriction base="xsd:string">
<enumeration value="today"/>
<enumeration value="yesterday"/>
<enumeration value="tomorrow"/>
<enumeration value="last7Days"/>
<enumeration value="thisMonth"/>
<enumeration value="lastMonth"/>
<enumeration value="nextMonth"/>
<enumeration value="thisWeek"/>
<enumeration value="lastWeek"/>
<enumeration value="nextWeek"/>
</restriction>
</simpleType>