Power Fx function
Date — Power Fx function reference
Build a date from parts.
Syntax
powerfx
Date( Year, Month, Day )
Examples
powerfx
Date(2026, 6, 13)
→ A date
powerfx
Date(2026, 12, 25)
powerfx
Date(Year(Today()), Month(Today()) + 1, 1)
Common mistakes & gotchas
- Out-of-range Day/Month values roll over rather than erroring — Date(2026, 13, 1) rolls forward into January 2027.
- Date() always returns midnight local time with no time-of-day component; combine with Time-based patterns if a specific time is also needed.
Related Power Fx functions
From Date & time