Overview
Syntax | TODAY() | Returns the current date. |
Notes
No parameter is required in the function.
Supports the date field - numerical value format. For example, TODAY()-1 returns the date of yesterday.
If you need to calculate the day before the current date for the extracted data, you can use DATEDELTA(TODAY(),-1). The following figure shows the result.
The following table describes the formula.
Formula | Description |
TODAY() | Returns the current date. |
DATEDELTA(TODAY(),-1) | Returns the date of the day before the current date. |
Example
Formula | Result | Note |
TODAY() | 2005-09-10 | If the system date is September 10, 2005, returns 2005-09-10. |
