Function name:
|
Usage:
|
AsDate
|
AsDate( aString ) Returns the date type for the specified string
Examples:
AsDate( "12/20/2000" ) = 12/20/2000 12:00 AM
|
BuildDate
|
BuildDate( DateTime, DateTime | DateTime, Time | DateTime, H,M,S | Y,M,D,H,M,S )
Returns a localized date time for the parameters passed. Returns a null value if the time or date passed is null.
Examples:
Assume that the field aDate is a datetime field from a database = June 19, 2008
( aDate, 12/30/1899 1:33:00 PM) = June 19, 2008 1:33 PM
( aDate, 2033) = June 19, 2008 8: 33 PM
( aDate, 15, 45, 20) = June 19, 2008 3:45 PM
(2008, 9, 20, 5, 22, 2) = September 20, 2008 5:22 AM year must use four digits
( aDate, blank ) = NULL no value returned
|
DateDiff
|
DateDiff( Date1, Date2 [,units = "d"])
Returns the difference, in whole numbers, between two dates in the units specified. Valid units are y,m,d,h,n,s
|
DateStr
|
DateStr (Date)
Returns the date string of the julian number.
|
Day
|
Returns the numeric day of the month (February 5th = 5) for the specified date
|
DOW
|
DOW(Date)
Returns a number indicating the day of the week for the specified julian date. 0 represents Sunday 6 represents Saturday 7 indicates an invalid julian date
|
DOWStr
|
DOWStr( aDate | aWeekdayIndex )
Returns the string value (i.e. "Monday") day of the week for the specified date or day of week index (DOY)
|
DOY
|
DOY( aDate )
Returns the numeric day of the year (January first =1) for the specified date
|
EndOfMonthContaining
|
EndOfMonthContaining (Date)
Returns the julian date of the end of the month containing the given date.
|
EndOfQtr
|
EndOfQtr (Date)
Returns the julian date of the end of the quarter with the given julian date.
|
EndOfQtrContaining
|
EndOfQtrContaining (QtrNum, Year)
Returns the julian date of the end of the given quarter in the given year.
|
FormatDate
|
FormatDate(DateTime, Format string)
Returns the specified date formatted as indicated in a format string
Assume that the field aDate is a datetime field from a database = Thursday, June 19, 2008 2:00:00 PM
Format mask elements:
mmm = Jun
mmmm = June
ddd = Thu
dddd = Thursday
ddddd = 6/19/2008
dddddd = Thursday, June 19, 2008
hh = 14
t = 2:00 PM
tt = 2:00:00 PM
dd/mm/yyyy
|
Julian
|
Julian (DateString)
Returns the julian of the given date string.
|
StartOfMonthContaining
|
StartOfMonthContaining(Julian Date)
Returns the julian date of the start of the month containing the given date.
|
StartOfQtr
|
StartOfQtr(Julian Date)
Returns the julian date of the start of the quarter with given julian date.
|
StartOfQtrContaining
|
StartOfQtrContaining(QtrNum, Year)
Returns the julian date of the start of the given quarter in the given year.
|
StartOfStudyQtr
|
Takes no parameters.
Returns the julian date of the start of the current study quarter.
|
StartOfYear
|
StartOfYear(YearNum)
Returns the julian date of the start of the given year.
|
SubtractMonths
|
SubtractMonths(Julian, num months)
Subtracts from the given julian the given num months and returns the resulting julian.
|
SubtractYears
|
SubtractYears(Julian, num years)
Subtracts from the given julian the given num years and returns the resulting julian.
|
Today
|
Today takes no parameters.
Teturns today's julian date.
|
WhichQtr
|
WhichQtr (Julian date)
Returns the quarter of the given julian.
|
WhichYear
|
WhichYear(Julian date)
Returns the year of the given julian.
|