Here you can determine the current date, i.e. the respective day on which the function is executed.
Therefore, the function is used to calculate deadlines or durations for example that are based on the current date. It also helps to generate unique document numbers for invoices, etc.
Syntax
today()
Return
date
Examples
Your result format may be different depending on your settings.
today()
Result: 12/31/2021 (US) and 31/12/2021 (UK) on New Year's Eve 2021.
​
today() + 7
Result: 12/31/2021 (US) and 31/12/2021 (UK) on Christmas Eve 2021.