# GC.Spread.Sheets.ConditionalFormatting.DateOccurringType

## Content

# Enumeration: DateOccurringType

[Sheets](../modules/GC.Spread.Sheets).[ConditionalFormatting](../modules/GC.Spread.Sheets.ConditionalFormatting).DateOccurringType

Specifies the date occurring type.

**`example`**
```javascript
//This example creates a rule.
var style = new GC.Spread.Sheets.Style();
style.backColor = "red";
var rule = new GC.Spread.Sheets.ConditionalFormatting.NormalConditionRule(GC.Spread.Sheets.ConditionalFormatting.RuleType.dateOccurringRule, [new GC.Spread.Sheets.Range(0,0,10,1)], style, null, null, null, null, null, GC.Spread.Sheets.ConditionalFormatting.DateOccurringType.nextWeek);
activeSheet.conditionalFormats.addRule(rule);
var d = new Date();
activeSheet.setValue(0, 0, d);
activeSheet.setValue(1, 0, new Date(d.setDate(d.getDate()+1)));
activeSheet.setValue(2, 0, new Date(d.setDate(d.getDate()+5)));
activeSheet.setValue(3, 0,new Date(d.setDate(d.getDate()+6)));
activeSheet.setValue(4, 0,new Date(d.setDate(d.getDate()+7)));
activeSheet.setValue(5, 0, new Date(d.setDate(d.getDate()+8)));
```

## Table of contents

### Enumeration members

- [last7Days](GC.Spread.Sheets.ConditionalFormatting.DateOccurringType#last7days)
- [lastMonth](GC.Spread.Sheets.ConditionalFormatting.DateOccurringType#lastmonth)
- [lastQuarter](GC.Spread.Sheets.ConditionalFormatting.DateOccurringType#lastquarter)
- [lastWeek](GC.Spread.Sheets.ConditionalFormatting.DateOccurringType#lastweek)
- [lastYear](GC.Spread.Sheets.ConditionalFormatting.DateOccurringType#lastyear)
- [nextMonth](GC.Spread.Sheets.ConditionalFormatting.DateOccurringType#nextmonth)
- [nextQuarter](GC.Spread.Sheets.ConditionalFormatting.DateOccurringType#nextquarter)
- [nextWeek](GC.Spread.Sheets.ConditionalFormatting.DateOccurringType#nextweek)
- [nextYear](GC.Spread.Sheets.ConditionalFormatting.DateOccurringType#nextyear)
- [thisMonth](GC.Spread.Sheets.ConditionalFormatting.DateOccurringType#thismonth)
- [thisQuarter](GC.Spread.Sheets.ConditionalFormatting.DateOccurringType#thisquarter)
- [thisWeek](GC.Spread.Sheets.ConditionalFormatting.DateOccurringType#thisweek)
- [thisYear](GC.Spread.Sheets.ConditionalFormatting.DateOccurringType#thisyear)
- [today](GC.Spread.Sheets.ConditionalFormatting.DateOccurringType#today)
- [tomorrow](GC.Spread.Sheets.ConditionalFormatting.DateOccurringType#tomorrow)
- [yesterday](GC.Spread.Sheets.ConditionalFormatting.DateOccurringType#yesterday)

## Enumeration members

### <a id="last7days" name="last7days"></a> last7Days

• **last7Days** = `3`

Specifies the last seven days.

___

### <a id="lastmonth" name="lastmonth"></a> lastMonth

• **lastMonth** = `5`

Specifies last month.

___

### <a id="lastquarter" name="lastquarter"></a> lastQuarter

• **lastQuarter** = `12`

Specifies last Quarter.

___

### <a id="lastweek" name="lastweek"></a> lastWeek

• **lastWeek** = `8`

Specifies last week.

___

### <a id="lastyear" name="lastyear"></a> lastYear

• **lastYear** = `15`

Specifies last Year.

___

### <a id="nextmonth" name="nextmonth"></a> nextMonth

• **nextMonth** = `6`

Specifies next month.

___

### <a id="nextquarter" name="nextquarter"></a> nextQuarter

• **nextQuarter** = `10`

Specifies next Quarter.

___

### <a id="nextweek" name="nextweek"></a> nextWeek

• **nextWeek** = `9`

Specifies next week.

___

### <a id="nextyear" name="nextyear"></a> nextYear

• **nextYear** = `13`

Specifies next Year.

___

### <a id="thismonth" name="thismonth"></a> thisMonth

• **thisMonth** = `4`

Specifies this month.

___

### <a id="thisquarter" name="thisquarter"></a> thisQuarter

• **thisQuarter** = `11`

Specifies this Quarter.

___

### <a id="thisweek" name="thisweek"></a> thisWeek

• **thisWeek** = `7`

Specifies this week.

___

### <a id="thisyear" name="thisyear"></a> thisYear

• **thisYear** = `14`

Specifies this Year.

___

### <a id="today" name="today"></a> today

• **today** = `0`

Specifies today.

___

### <a id="tomorrow" name="tomorrow"></a> tomorrow

• **tomorrow** = `2`

Specifies tomorrow.

___

### <a id="yesterday" name="yesterday"></a> yesterday

• **yesterday** = `1`

Specifies yesterday.