Power Fx function
DateTimeValue — Power Fx function reference
Parse text into a datetime.
Syntax
powerfx
DateTimeValue( DateTimeText [, LanguageCode ] )
Examples
powerfx
DateTimeValue("2026-06-13 09:30")→ A datetime
powerfx
DateTimeValue("2026-06-13 09:30")powerfx
DateTimeValue(txtTimestamp.Text)
Common mistakes & gotchas
- Like DateValue, ambiguous formats depend on locale — prefer ISO 8601-style strings ("YYYY-MM-DD HH:MM") for a fixed-format source like an API response.
- The result carries both date and time — compare it against a Today()-based date-only value with DateValue() first to avoid time-of-day mismatches.
Related Power Fx functions
From Date & time