Calculates the internal system date for a provided month, day and year combination.

DATE(Month, Day, Year)

Month: the integer value of the month for a given date (1-12).

Day: the integer value of the day for a given date (1-31).

Year: the four-digit year value for a given date.

DATE(1,1,2017) will return the internal system value of the date 01/01/2017 (20170101).

DATE(1,1,YEAR(ACD)) will return the January 1 of the year of the person's ACD.

If a date is calculated that exceeds the end of the month, the actual last day for the month is returned. For example, if the formula resulted in a date 04/31/2008, the system would return the date 04/30/2008 instead