 |
Online Help System
|
 |
Back to Brilliant Database Web-Site |
Write to Support |
Help Index
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.
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.
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 database software record field value with name "Order Date".
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;
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 database software record field value with name
"Order Date".
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
|
