Converts date and time components to a date/time value.
The Date function converts individual Year, Month, and Day values to a Date/Time value. The time portion is midnight.
If Year is between 0 and 1899 (inclusive), the function adds that value to 1900 to calculate the year. 70 becomes 1970.
If Month is less than 1 or more than 12, the result subtracts or adds that many months from the beginning of the specified year.
If Day is greater than the number of days in the specified month, the function adds that many days to the first day of the month and returns the corresponding date from a subsequent month. If Day is less than 1, the function subtracts that many days, plus 1, from the first day of the specified month.
The Time function converts individual Hour, Minute, and Second values to a Date/Time value. The result has no date associated with it.
Also see working with dates and times for more information.
Date( Year, Month, Day )
Time( Hour, Minute, Second )
If a user typed 1979 in a text-input control named HireYear, 3 in a text-input control named HireMonth, and 17 in a text-input control named HireDay, this function would return 3/17/1979:
Date(Value(HireYear.Text), Value(HireMonth.Text), Value(HireDay.Text))
If a user typed 14 in a text-input control named BirthHour, 50 in a text-input control named BirthMinute, and 24 in a text-input control named BirthSecond, this function would return 02:50:24 p.
Text(Time(Value(BirthHour.Text), Value(BirthMinute.Text), Value(BirthSecond.Text)), "hh:mm:ss a/p")