DATE (Report Builder 1.0)

Returns a datetime value given a year, month, and day at 12:00:00 AM.

Syntax

DATE(year, month, day)

year

Specifies the integer representing the year as a four digit number.

month

Specifies the integer representing the month (1-12).

day

Specifies the integer representing the day (1-31).

Example

Formula

Result

DATE(2004, 1, 25)

1/25/2004 12:00:00 AM