Power Fx function
Today — Power Fx function reference
Current date at midnight.
Syntax
powerfx
Today()
Examples
powerfx
Today()
→ A date
powerfx
Filter(Tasks, DueDate = Today())
powerfx
DateAdd(Today(), 30, TimeUnit.Days)
Common mistakes & gotchas
- Today() returns midnight in the device's local time — comparing it to a DateTime column with a non-midnight time component needs normalization first.
- Like Now(), Today() is device-local, so cross-user scheduling logic that must be time-zone-consistent needs a server-side/UTC anchor instead.
Related Power Fx functions
From Date & time