## Date Range functions

Date range functions are preset date ranges that can be used in formulas.

WeekToDateFromSun

MonthToDate

YearToDate

Last7Days

Last4WeeksToSun

LastFullWeek

LastFullMonth

AllDatesToToday

AllDatesToYesterday

AllDatesFromToday

AllDatesFromTomorrow

Aged0To30Days, Aged31To60Days, Aged61To90Days

Over90Days

Next30Days, Next31To60Days, Next61To90Days, Next91To365Days

Calendar1stQtr, Calendar2ndQtr, Calendar3rdQtr, Calendar4thQtr

Calendar1stHalf, Calendar2ndHalf

LastYearMTD

LastYearYTD

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com