|
Date range functions display various date range information that you can utilize within your formulas.
Function | Description | Arguments |
---|---|---|
WeekToDateFromSun | Specifies a range of Date values that includes all days from last Sunday to today (including today). | (no arguments) |
MonthToDate | Specifies a range of Date values that includes all dates from the first day of the month to today. | (no arguments) |
YearToDate | Specifies a range of Date values that includes all days from the first day of the calendar year to today. | (no arguments) |
Last7Days | Specifies a range of Date values that includes all dates from seven days ago to today (including today). | (no arguments) |
Last4WeeksToSun | Specifies a range of dates that includes the four weeks previous to last Sunday. A week begins on a Monday and ends on a Sunday. | (no arguments) |
LastFullWeek | Specifies a range of Date values that includes all dates from Sunday to Saturday of the previous week. | (no arguments) |
LastFullMonth | Specifies a range of Date values that includes all dates from the first to last day of the previous month. | (no arguments) |
AllDatesToToday | Specifies a range of Date values that includes every day up to and including today. | (no arguments) |
AllDatesToYesterday | Specifies a range of Date values that includes every day up through the previous day. AllDatesToYesterday includes all dates before today but does not include the present day. | (no arguments) |
AllDatesFromToday | Specifies a range of Date values that includes any date from the present day to any future Date value that may appear in a field. AllDatesFromToday includes the present day. | (no arguments) |
AllDatesFromTomorrow | Specifies a range of Date values that fall after the present day. AllDatesFromTomorrow does not include the present day but does include any future date. | (no arguments) |
Aged0To30Days Aged31To60Days Aged61To90Days | Specifies a range of Date values that fall within a certain time period before the present date. If the current date is 12/30/98, Aged0To30Days specifies the period from 12/1/98 to the present date, Aged31To60Days specifies the period from 11/1/98 to 11/30/98, and Aged61To90Days specifies the period 10/2/98 to 10/31/98. | (no arguments) |
Over90Days | Specifies a range of Date values that includes all values that are more than 90 days older than the current date. | (no arguments) |
Next30Days Next31To60Days Next61To90Days Next91To365Days | Specifies a range of Date values that includes all dates in the period specified starting from and including today. | (no arguments) |
Calendar1stQtr Calendar2ndQtr Calendar3rdQtr Calendar4thQtr | Specifies a range of Date values that falls within the first, second, third, or fourth quarter of the current calendar year. The first quarter of the calendar year includes all dates from January 1 through March 31. The second quarter includes all dates from April 1 through June 30. The third quarter includes all dates from July 1 through September 30. The fourth quarter includes all dates from October 1 through December 31. | (no arguments) |
Calendar1stHalf Calendar2ndHalf | Specifies a range of Date values that includes all dates that fall within the first or second half of the current calendar year, respectively. The first half of the calendar year includes all dates from January 1 through June 30. The second half of the calendar year includes all dates from July 1 through December 31. | (no arguments) |
LastYearMTD | Specifies a range of Date values in the previous year that matches the current month to date. | (no arguments) |
LastYearYTD | Specifies a range of Date values that includes all dates in the last year up to the current date last year. | (no arguments) |
|