### Date Range

Note that all the following functions cannot be used to return a value singly.

- Aged0To30Days()
- Aged31To60Days()
- Aged61To90Days()
- AllDatesFromToday()
- AllDatesFromTomorrow()
- AllDatesToToday()
- AllDatesToYesterday()
- Calendar1stHalf()
- Calendar1stQtr()
- Calendar2ndHalf()
- Calendar2ndQtr()
- Calendar3rdQtr()
- Calendar4thQtr()
- Last4WeeksToSun()
- Last7Days()
- LastFullMonth()
- LastFullWeek()
- LastYearMTD()
- LastYearYTD()
- MonthToDate()
- Next30Days()
- Next31To60Days()
- Next61To90Days()
- Next91To365Days()
- Over90Days()
- WeekToDateFromSun()
- YearToDate()

#### Aged0To30Days()

This function returns a range of Data values that is within the previous 30 days from today. For example, if today is 10/14/99, the return range is from 09/15/99 to 10/14/99.

Example

The return value of the following statement is Not Expired.

    if (ToDate(1999,9,20) in Aged0To30Days())
      return "Not Expired"
    else
      return "Expired"

#### Aged31To60Days()

This function returns a range of Data values that is within the previous 31 to 60 days from today date. For example, if today is 10/13/99, the return range is from 08/12/99 to 09/13/99.

Example

If today is 10/13/99, the return value of the following statement is false.

`return ToDate(1998, 4, 20) in Aged31To60Days()`

#### Aged61To90Days()

This function returns a range of Data values that is within the previous 61 to 90 days from today date. For example, if today is 10/13/99, the return range is from 07/13/99 to 08/11/99.

Example

If today is 10/13/99, the return value of the following statement is false.

`return ToDate(1998, 4, 20) in Aged61To90Days()`

#### AllDatesFromToday()

This function returns a range of Data values that include any date from the present day to a date about 10000 years in the future Data value. For example, if today is 04/15/98, the return range is from 04/15/98 to the future.

Example

If today is 10/10/99, the return value of the following statement is false.

`return ToDate(1998, 4, 20) in AllDatesFromToday()`

#### AllDatesFromTomorrow()

This function returns a range of Data values that include any date from tomorrow to any future Data value. For example, if today is 04/15/98, the return range is from 04/16/98 to the future.

Example

If today is 10/10/99, the return of the following statement is false.

`return ToDate(1998, 4, 20) in AllDatesFromTomorrow()`

#### AllDatesToToday()

This function returns a range of Data values that include all dates up through the present day. For example, if today is 4/15/98, the return range is from the past to 04/15/1998.

Example

If today is 10/10/99, the return value of the following statement is true.

`return ToDate(1998, 4, 20) in AllDatesToToday()`

#### AllDatesToYesterday()

This function returns a range of Data values that include all dates up through the previous day. For example, if today is 4/15/98, the return range is from the past to 04/14/1998.

Example

If today is 10/10/99, the return value of the following statement is true.

`return ToDate(1998, 4, 20) in AllDatesToYesterday()`

#### Calendar1stHalf()

This function returns a range of Data values that include all dates from January 1st through June 30th.

Example

If today is 10/10/99, the return value of the following statement is false.

`return Today() in Calendar1stHalf()`

#### Calendar1stQtr()

This function returns a range of Data values that include all dates from January 1st through to March 31st.

Example

If today is 10/10/99, the return value of the following statement is false.

`return Today() in Calendar1stQtr()`

#### Calendar2ndHalf()

This function returns a range of Data values that include all dates from July 1st through to December 31st.

Example

If today is 10/10/99, the return value of the following statement is true.

`return Today() in Calendar2ndHalf()`

#### Calendar2ndQtr()

This function returns a range of Data values that include all dates from April 1st through to June 30th.

Example

If today is 10/10/99, the return value of the following statement is false.

`return Today() in Calendar2ndQtr()`

#### Calendar3rdQtr()

This function returns a range of Data values that include all dates from July 1st through to September 30th.

Example

If today is 10/10/99, the return value of the following statement is false.

`return Today() in Calendar3rdQtr()`

#### Calendar4thQtr()

This function returns a range of Data values that include all dates from October 1st through December 31st.

Example

If today is 10/10/99, the return value of the following statement is true.

`return Today() in Calendar4thQtr()`

#### Last4WeeksToSun()

This function returns a range of Data values that include the four weeks previous to last Sunday. For example, if today is 4/15/95, the return range is from 3/13/95 to 4/9/95.

Example

If today is 10/10/99, the return value of the following statement is false.

`return ToDate(1999, 4, 20) in Last4WeeksToSun()`

#### Last7Days()

This function returns a range of Data values that include all dates from seven days ago to today (including today). For example, if today is 04/15/98, the return range is from (include) 04/09/98 to 04/15/98.

Example

If today is 10/10/99, the return value of the following statement is false.

`return ToDate(1999, 4, 20) in Last7Days()`

#### LastFullMonth()

This function returns a range of Data values that include all dates from the first to the last day of the previous month. For example, if today is 04/15/98, the return range is from 03/01/98 to 03/31/98.

Example

If today is 10/10/99, the return value of the following statement is false.

`return ToDate(1999, 4, 20) in LastFullMonth()`

#### LastFullWeek()

This function returns a range of Data values that include all dates from the Sunday to the Saturday of the previous week. For example, if today is 04/10/95, the return range is from 04/02/95 to 04/08/95.

Example

If today is 10/10/99, the return value of the following statement is false.

`return ToDate(1999, 4, 20) in LastFullWeek()`

#### LastYearMTD()

This function returns a range of Data values that fall on any date in the current month last year, up to the current date last year. For example, if today is 04/15/98, the return range is from 04/01/97 to 04/15/97.

Example

If today is 10/10/99, the return value of the following statement is false.

`return ToDate(1999, 4, 20) in LastYearMTD()`

#### LastYearYTD()

This function returns a range of Data values that include all dates in the last year, up to the current date last year. For example, if today is 04/15/98, the return range is from 01/01/97 to 04/15/97

Example

If today is 10/10/99, the return value of the following statement is true.

`return ToDate(1998, 4, 20) in LastYearYTD()`

#### MonthToDate()

This function returns a range of Data values that include all dates from the first day of the month to today. For example, if today is 04/15/98, the return range is from 04/01/98 to 04/15/98.

Example

If today is 10/10/99, the return value of the following statement is true.

`return ToDate(1999, 10, 2) in MonthToDate()`

#### Next30Days()

This function returns a range of Data values that include all days in the next 30 days starting from today (including today). For example, if today is 04/15/98, the return range is from 04/15/98 to 05/15/98.

Example

If today is 10/10/99, the return value of the following statement is false.

`return ToDate(1999, 10, 2) in Next30Days()`

#### Next31To60Days()

This function returns a range of Data values that include all days in the next 31 to 60 days starting from today. For example, if today is 04/15/98, the return range is from 05/16/98 to 06/14/98.

Example

If today is 10/10/99, the return value of the following statement is false.

`return ToDate(1999, 10, 2) in Next31To60Days()`

#### Next61To90Days()

This function returns a range of Data values that include all days in the next 61 to 90 days starting from today. For example, if today is 04/15/98, the return range is from 06/15/98 to 07/14/98.

Example

If today is 10/10/99, the return value of the following statement is false.

`return ToDate(1999, 4, 20) in Next61To90Days()`

#### Next91To365Days()

This function Returns a range of Data values that include all days in the next 91 to 365 days starting from today. For example, if today is 04/15/98, the return range is from 07/15/98 to 04/15/99.

Example

If today is 10/10/99, the return value of the following statement is false.

`return ToDate(1999, 4, 20) in Next91To365Days()`

#### Over90Days()

This function returns a range of Data values that include all days that are more than 90 days older than the current date. For example, if today is 04/15/98, the return range is from the past to 01/14/98.

Example

If today is 10/10/99, the return value of the following statement is true.

`return ToDate(1999, 4, 20) in Over90Days()`

#### WeekToDateFromSun()

This function returns a range of Data values that include all days from last Sunday to today (including today). For example, if today is 04/13/95, the return range is from 04/09/95 to 04/13/95.

Example

If today is 10/10/99, the return value of the following statement is false.

`return ToDate(1999, 4, 20) in WeekToDateFromSun()`

#### YearToDate()

This function returns a range of Data values that include all days from the first day of the calendar year to today (including today). For example, if today is 04/15/98, the return range is from 01/01/98 to 04/15/98.

Example

If today is 10/10/99, the return value of the following statement is true.

`return ToDate(1999, 4, 20) in YearToDate(`)