TODAY function
TODAY() TODAY()
Returns
Number
A sequential serial number representing the current date.
Returns the current date, with the time set to midnight. Use NOW instead if the current time should also be returned.
The value returned from this function can be set as the initial value displayed by a date and time field.
Examples
TODAY()TODAY()
Returns the current date. The time is set to midnight.
FORMATDATE(TODAY(),
DateFormat.Full)FORMATDATE(TODAY();
DateFormat,Full)
Returns today's date, formatted as a text string.