TODAY

The TODAY function returns the current date in datetime format. The time returned by this function is always 00:00:00. This function is useful for making calculations that depend on the number of days elapsed or the number of days that will elapse until a certain event.

Syntax

TODAY()

Parameters

The TODAY function does not accept arguments.

Returned value

The TODAY function returns the current date in datetime format. The returned time is 00:00:00.

Additional Information

The function returns the date of the server or computer where the Power BI file is hosted (if we are running Power BI Desktop, the function will return the date of our computer).

Examples

This first example shows the current date:

TODAY function: Example of use

This second example shows the number of weeks elapsed from the sale date to today (calculation involving the DATEDIFF and TODAY functions):

TODAY function. Example of use

Related functions
Category
Date and time
Submitted by admin on Mon, 12/03/2018 - 23:26