TODAY()

Use the TODAY() function to obtain the current system date as a datetime value.

Function Format

TODAY()

Note: The time portion of the current DateTime is ignored.

The current system date is returned as a datetime value without the time portion.

For more information on obtaining the current system date and system time, see NOW().

Examples

Using a current system date of Aug 22, 2013:

DAY(TODAY()) = 22

MONTH(TODAY()) = 8

YEAR(TODAY())= 2013