TODAY - Returning the Current Date- FineBI Help Document

Last update：December 15, 2024

Overview

Syntax

TODAY()

Returns the current date.

Notes

No parameter is required in the function.
Supports the date field - numerical value format. For example, TODAY()-1 returns the date of yesterday.

If you need to calculate the day before the current date for the extracted data, you can use DATEDELTA(TODAY(),-1). The following figure shows the result.

image 1.png

The following table describes the formula.

Formula	Description
TODAY()	Returns the current date.
DATEDELTA(TODAY(),-1)	Returns the date of the day before the current date.

Example

Formula	Result	Note
TODAY()	2005-09-10	If the system date is September 10, 2005, returns 2005-09-10.

Helpful
Not helpful
Only read

中文（简体）中文（繁體）日本語

English

TODAY - Returning the Current Date

Overview

Notes

Example

附件列表