- DAX Functions Tutorial
- DAX Functions - Home
- DAX Functions - Introduction
- DAX Parameter Naming Conventions
- Description Structure
- DAX Functions - Aggregation
- DAX Functions - Filter
- DAX Functions - Time Intelligence
- DAX Functions - Date and Time
- DAX Functions - Information
- DAX Functions - Logical
- Math & Trigonometric Functions
- DAX Functions - Parent & Child
- DAX Functions - Statistical
- DAX Functions - Text
- DAX Functions - Other
- DAX Functions Useful Resources
- DAX Functions - Quick Guide
- DAX Functions - Useful Resources
- DAX Functions - Discussion
DAX Date & Time - TODAY function
Description
Returns the current date.
Syntax
TODAY ()
Parameters
No parameters for this function.
Return Value
Current date in datetime format.
Remarks
DAX TODAY function is useful when you need to have the current date displayed on a workbook, regardless of when you open the workbook. It is also useful for calculating intervals.
DAX functions - TODAY and NOW both return the current date. However,
- TODAY returns the time as 12:00:00 always.
- NOW returns the time precisely.
Example
= YEAR (TODAY () – [JoiningDate]) – 1900 returns the number of years of service for each employee.
dax_functions_date_time.htm
Advertisements