DateTime functions
The Power Query Formula Language is a powerful query language optimized for building queries that mashup data. It's a functional, case sensitive language similar to F#, which can be used with Power Query in Excel, Get & Transform in Excel 2016, and Power BI Desktop. To learn more, see the PowerQueryName reference.
| Function | Description |
|---|---|
| DateTime.AddZone | Adds the timezonehours as an offset to the input datetime value and returns a new datetimezone value. |
| DateTime.Date | Returns a date part from a DateTime value |
| DateTime.FixedLocalNow | Returns a DateTime value set to the current date and time on the system. |
| DateTime.From | Returns a datetime value from a value. |
| DateTime.FromFileTime | Returns a DateTime value from the supplied number. |
| DateTime.FromText | Returns a DateTime value from a set of date formats and culture value. |
| DateTime.IsInCurrentHour | Indicates whether the given datetime value occurs during the current hour, as determined by the current date and time on the system. |
| DateTime.IsInCurrentMinute | Indicates whether the given datetime value occurs during the current minute, as determined by the current date and time on the system. |
| DateTime.IsInCurrentSecond | Indicates whether the given datetime value occurs during the current second, as determined by the current date and time on the system. |
| DateTime.IsInNextHour | Indicates whether the given datetime value occurs during the next hour, as determined by the current date and time on the system. |
| DateTime.IsInNextMinute | Indicates whether the given datetime value occurs during the next minute, as determined by the current date and time on the system. |
| DateTime.IsInNextNHours | Indicates whether the given datetime value occurs during the next number of hours, as determined by the current date and time on the system. |
| DateTime.IsInNextNMinutes | Indicates whether the given datetime value occurs during the next number of minutes, as determined by the current date and time on the system. |
| DateTime.IsInNextNSeconds | Indicates whether the given datetime value occurs during the next number of seconds, as determined by the current date and time on the system. |
| DateTime.IsInNextSecond | Indicates whether the given datetime value occurs during the next second, as determined by the current date and time on the system. |
| DateTime.IsInPreviousHour | Indicates whether the given datetime value occurs during the previous hour, as determined by the current date and time on the system. |
| DateTime.IsInPreviousMinute | Indicates whether the given datetime value occurs during the previous minute, as determined by the current date and time on the system. |
| DateTime.IsInPreviousNHours | Indicates whether the given datetime value occurs during the previous number of hours, as determined by the current date and time on the system. |
| DateTime.IsInPreviousNMinutes | Indicates whether the given datetime value occurs during the previous number of minutes, as determined by the current date and time on the system. |
| DateTime.IsInPreviousNSeconds | Indicates whether the given datetime value occurs during the previous number of seconds, as determined by the current date and time on the system. |
| DateTime.IsInPreviousSecond | Indicates whether the given datetime value occurs during the previous second, as determined by the current date and time on the system. |
| DateTime.LocalNow | Returns a datetime value set to the current date and time on the system. |
| DateTime.Time | Returns a time part from a DateTime value. |
| DateTime.ToRecord | Returns a record containing parts of a DateTime value. |
| DateTime.ToText | Returns a text value from a DateTime value. |
Show: