today

To return the current date (without time)

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)

  • 31/12/2021 (UK)

on New Year's Eve 2021.

today() + 7

Result:

  • 12/31/2021 (US)

  • 31/12/2021 (UK)

on Christmas Eve 2021.

year(today())

Result: 2021 on New Year's Eve 2021.

See also

now, which returns the current timestamp.

Do you want to dive deeper into the topic? Take a look at the corresponding part of our video tutorial.

Last updated