Date Ranges


Date range functions display various date range information that you can utilize within your formulas.

Table C-7: Date range functions

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)




Mastering Business Analysis with Crystal Reports 9
Mastering Business Analysis with Crystal Reports 9 (Wordware Applications Library)
ISBN: 1556222939
EAN: 2147483647
Year: 2004
Pages: 177
Authors: Chris Tull

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net