Fabric Plan Community Logo
Sign in

DATE.NOW

The DATE.NOW function returns the current date and time based on the system settings. This function is commonly used to capture timestamps, calculate durations, and display the current date and time in reports.

Syntax

DATE.NOW

Return value

Returns the current date and time as a datetime value.

Example

DATE.NOW

Returns the current date and timestamp, such as 18/08/2023, 4:02:19 PM.

Excel equivalent

NOW

Fabric Plan
Enterprise planning, integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co-engineered with Lumel.
CERTIFIED BY
Fabric Planning is certified by IBCS
Microsoft, Azure, Copilot, Excel, Fabric IQ, Microsoft Entra, Microsoft Fabric, Microsoft Teams, OneLake, Outlook, Power Automate, Power BI and SharePoint are trademarks of the Microsoft group of companies. IBCS is a registered trademark of IBCS Association. All other trademarks are the property of their respective owners.

This community is operated independently by Lumel. Nothing on this site constitutes a representation or warranty by Microsoft.