DATE
From LongJump Support Wiki
The DATE function creates a date in the standard date format from a text string representing the day, month and year. You can also optionally include the time with this function.
- Syntax
DATE(year, month, day [,hour, minute, second])
- Return
- Date in the format defined by Date Format
- Example
DATE (1988, 3, 7, 3, 22, 45) = '03/07/1988 03:22:45'