Power Fx function
Text (format) — Power Fx function reference
Format a date as text.
Syntax
powerfx
Text( Value, Format [, LanguageCode ] )
Examples
powerfx
Text(Now(), "dd mmm yyyy")
→ "13 Jun 2026"
powerfx
Text(Now(), "mmmm d, yyyy")
powerfx
Text(DateDiff(StartDate, Today(), TimeUnit.Years)) & " years"
Common mistakes & gotchas
- Text() format codes are Excel-style (mmm/dd/yyyy), not the .NET-style codes ("MMM dd") seen elsewhere in Power Platform — mixing conventions is a very common formatting bug.
- A named format like DateTimeFormat.ShortDate follows the device locale automatically; a literal custom string like "dd/mm/yyyy" forces that exact layout regardless of locale.
Related Power Fx functions
From Date & time