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()