aspose.cells
Class TimePeriodType

Utility class containing constants. Used in a FormatConditionType.TimePeriod conditional formatting rule. These are dynamic time periods, which change based on the date the conditional formatting is refreshed / applied.

Field Summary
const  NumberTODAY
           Today's date.
const  NumberYESTERDAY
           Yesterday's date.
const  NumberTOMORROW
           Tomorrow's date.
const  NumberLAST_7_DAYS
           A date in the last seven days.
const  NumberTHIS_MONTH
           A date occuring in this calendar month.
const  NumberLAST_MONTH
           A date occuring in the last calendar month.
const  NumberNEXT_MONTH
           A date occuring in the next calendar month.
const  NumberTHIS_WEEK
           A date occuring this week.
const  NumberLAST_WEEK
           A date occuring last week.
const  NumberNEXT_WEEK
           A date occuring next week.
 

Field Detail

TODAY

const Number TODAY
Today's date.

YESTERDAY

const Number YESTERDAY
Yesterday's date.

TOMORROW

const Number TOMORROW
Tomorrow's date.

LAST_7_DAYS

const Number LAST_7_DAYS
A date in the last seven days.

THIS_MONTH

const Number THIS_MONTH
A date occuring in this calendar month.

LAST_MONTH

const Number LAST_MONTH
A date occuring in the last calendar month.

NEXT_MONTH

const Number NEXT_MONTH
A date occuring in the next calendar month.

THIS_WEEK

const Number THIS_WEEK
A date occuring this week.

LAST_WEEK

const Number LAST_WEEK
A date occuring last week.

NEXT_WEEK

const Number NEXT_WEEK
A date occuring next week.
See Also:
          Aspose.Cells Documentation - the home page for the Aspose.Cellss Product Documentation.
          Aspose.Cells Support Forum - our preferred method of support.

We guarantee a prompt response to any inquiry!

© 2003-2017 Aspose Pty Ltd. All rights reserved.