Function name:

Usage:

@DateStr

@DateStr (juliandate) Returns the date string of the julian number.

@DOW

@DOW(juliandate) 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

@EndOfMonthContaining

@EndOfMonthContaining (Julian Date) Returns the julian date of the end of the month containing the given date.

@EndOfQtr

@EndOfQtr (Julian 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.

@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, returns 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.