Database Reference
In-Depth Information
Standard Time Periods
Table 7-4 shows standard time periods used within TI formulas.
TABle 7-4
Standard Time Periods
PErIoD
ExAMPLE
Year
Year-1, year+2
Quarter
quarter, Quarter-4
Month
Month-2
Week
Week-51
Day
Day-9, day+2
Hour
Hour-12
Minute
minute-30
Second
second+5
Standard Time Period Functions
TI formulas can use the time period functions provided in Table 7-5 to modify
any standard time period via usage of the dot operator (.).
TABle 7-5
Standard Time Period Functions
FuNCTIoN
uSE
FirstQuarter
Specifies the first quarter in a year.
LastQuarter
Specifies the last quarter in a year.
FirstMonth
Specifies the first month in a year or quarter.
LastMonth
Specifies the last month in a year or quarter.
FirstWeek
Specifies the first week in a year, quarter, or month.
LastWeek
Specifies the last week in a year, quarter, or month.
Specifies the first day in a week, month, or larger time
period.
FirstDay
LastDay
Specifies the last day in a week, month, or larger time
period.
FirstHour
Specifies the first hour in a day, week, or larger time
period.
LastHour
Specifies the last hour in a day, week, or larger time
period.
