Fabric Plan Community Logo
Sign in

DATE.FORMAT

The DATE.FORMAT() function returns the current date in the specified string format. If you do not specify a format, the function returns the date in the format based on the user's browser locale.

Syntax

DATE.FORMAT([format])

Arguments

  • format (optional): The format in which to display the current date.

Return value

Returns the current date as a formatted string.

Examples

DATE.FORMAT()

Returns the current date in the browser locale format, such as 11/6/24.

DATE.FORMAT("DD MM YY")

Returns the current date in the specified format, such as 11 06 24.

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.