These FAQ items focus on syntax, refresh behavior, and combined calculations, covering 3 common questions about using TODAY.
FAQ
Why does TODAY not return a result?
- Check whether the current field is a Formula field.
- Make sure the syntax is
TODAY()and that the parentheses are included. - Save the formula and check whether the field has recalculated normally.
Can TODAY take arguments?
- The standard syntax is
TODAY(). - It does not require any arguments.
- If you need conditional logic, wrap it with other functions outside TODAY.
What is TODAY commonly used for?
- It can display the current date.
- It can compare the current date with a deadline field.
- It can also serve as a base value in other date or conditional formulas.
Glossary
| Term | Definition |
|---|---|
| TODAY | A function that returns the current date, usually without a time component. |
| Formula field | A field type in a multidimensional table that calculates results automatically from a formula. |
| Current date | The date value returned based on the system date or the table recalculation time. |