<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>