Today
Returns today's date (year, month, day), but does not include hours, minutes, and seconds (default is 00:00:00). If you want to include hours, minutes, and seconds, use the NOW function.
You can directly use this function to return the year, month, and day, see example one;
You can also use it with functions like DATEADD or DATETIME_DIFF, such as subtracting the current time from {Deadline} to display the project's countdown, see example two.
Note: The result returned by this function will only update when the formula is recalculated or the database is refreshed.