TODAY

Description

The TODAY function evaluates to the current date.

Usage

TODAY()

Remarks

When working offline, the TODAY() function will evaluate to the date in the

Examples

Calculating ages

The TODAY can be used with together with the YEARFRAC function to calculate ages from birthdates. For example:

FLOOR(YEARFRAC(DOB, TODAY()))

Calculating delays

You can also use the DAYS function to find the number of days between today and some event in the past. For example, if you are providing emergency case management, you might want to know how long an urgent case has been open. If you have a date field with the code CASE_OPENED, you could calculate the number of days the case has been opened using the formula:

DAYS(TODAY(), CASE_OPENED)

Note that the order of arguments for YEARFRAC and DAYS is switched. We have inherited this infelicity from Excel.

Next item
UNION