Brilliant Database Software - Home
Database software - Online Help System

Online Help System

Back to Brilliant Database Web-Site | Write to Support | Help Index



Date Functions

table border="0" width="100%" cellspacing="0" cellpadding="4" bgcolor="#00000077">
Date Functions

Note. Date functions use their own internal numeric representation of dates. However, the mode of the date representation can by modified so that the result of the formula is displayed as a date instead of numerals. To modify the mode, use the formatting string starting with the word Date (not Math), e.g., "date dddd, mmm d yyyy" will be displayed as Monday, Feb 2 2004

dateSerial (Year, Month, Day)

Returns a date for the specified year, month, and day. The function converts the date specified by year, month, and day into the internal format.

Examples:

datePart(dateSerial(1983,4,16),|Year|), returns 1983;

datePart(dateSerial(1983,4,16,|Day|), returns 16.

datePart (Date, |Part|)

Returns the specified part of the date.

Examples:

datePart(dateSerial(1983,4,16),|Year|), returns 1983;

datePart([Order Date],|Month|), returns month of the date stored in the record field value with name "Order Date".

dateCurrent()

Returns the current system date. The function converts the date specified by year, month, and day into the internal format. The return value may only be used within the application.

Examples:

datePart(dateCurrent()), returns today's day;

dateDiff (dateA, dateB, |Interval|)

Returns the value specifying the number of time intervals between two dates specified. The interval parameter contains the interval of time to calculate the difference between dateA and dateB.

Examples:

dateDiff(dateSerial(2004,10,20), dateSerial(2004,10,16), |Day|), returns 20-16=4

dateDiff(dateSerial(dateCurrent(), [Order Date], |Month|), returns the number of months since the date stored in the record field value with name "Order Date".

dateAdd (dateA, Interval_len, |Interval|)

Returns the date shifted from date dateA to a specified interval Interval_len defined in days, months or years. The unit measure is defined by parameter Interval.

 Examples:

dateAdd(dateSerial(2004,1,1),5,|Day|), returns 6 January 2004

dateAdd(dateSerial(2004,1,1),32,|Day|), returns 2 February 2004

dateAdd(dateSerial(2004,1,1),2,|Month|), returns 1 March 2004

 




All topics in the "Functions Description" section: