DateTime functions
These functions create and manipulate datetime and datetimezone values.
| Name | Description |
|---|---|
| DateTime.AddZone | Adds timezone information to the datetime value. |
| DateTime.Date | Returns the date component of the given date, datetime, or datetimezone value. |
| DateTime.FixedLocalNow | Returns the current date and time in the local timezone. This value is fixed and doesn't change with successive calls. |
| DateTime.From | Creates a datetime from the given value. |
| DateTime.FromFileTime | Creates a datetime from a 64-bit long number. |
| DateTime.FromText | Creates a datetime from local and universal datetime formats. |
| DateTime.IsInCurrentHour | Indicates whether this datetime occurs during the current hour, as determined by the current date and time on the system. |
| DateTime.IsInCurrentMinute | Indicates whether this datetime occurs during the current minute, as determined by the current date and time on the system. |
| DateTime.IsInCurrentSecond | Indicates whether this datetime occurs during the current second, as determined by the current date and time on the system. |
| DateTime.IsInNextHour | Indicates whether this datetime occurs during the next hour, as determined by the current date and time on the system. This function returns false when passed a value that occurs within the current hour. |
| DateTime.IsInNextMinute | Indicates whether this datetime occurs during the next minute, as determined by the current date and time on the system. This function returns false when passed a value that occurs within the current minute. |
| DateTime.IsInNextNHours | Indicates whether this datetime occurs during the next number of hours, as determined by the current date and time on the system. This function returns false when passed a value that occurs within the current hour. |
| DateTime.IsInNextNMinutes | Indicates whether this datetime occurs during the next number of minutes, as determined by the current date and time on the system. This function returns false when passed a value that occurs within the current minute. |
| DateTime.IsInNextNSeconds | Indicates whether this datetime occurs during the next number of seconds, as determined by the current date and time on the system. This function returns false when passed a value that occurs within the current second. |
| DateTime.IsInNextSecond | Indicates whether this datetime occurs during the next second, as determined by the current date and time on the system. This function returns false when passed a value that occurs within the current second. |
| DateTime.IsInPreviousHour | Indicates whether this datetime occurs during the previous hour, as determined by the current date and time on the system. This function returns false when passed a value that occurs within the current hour. |
| DateTime.IsInPreviousMinute | Indicates whether this datetime occurs during the previous minute, as determined by the current date and time on the system. This function returns false when passed a value that occurs within the current minute. |
| DateTime.IsInPreviousNHours | Indicates whether this datetime occurs during the previous number of hours, as determined by the current date and time on the system. This function returns false when passed a value that occurs within the current hour. |
| DateTime.IsInPreviousNMinutes | Indicates whether this datetime occurs during the previous number of minutes, as determined by the current date and time on the system. This function returns false when passed a value that occurs within the current minute. |
| DateTime.IsInPreviousNSeconds | Indicates whether this datetime occurs during the previous number of seconds, as determined by the current date and time on the system. This function returns false when passed a value that occurs within the current second. |
| DateTime.IsInPreviousSecond | Indicates whether this datetime occurs during the previous second, as determined by the current date and time on the system. This function returns false when passed a value that occurs within the current second. |
| DateTime.LocalNow | Returns the current date and time in the local timezone. |
| DateTime.Time | Returns the time part of the given datetime value. |
| DateTime.ToRecord | Returns a record containing the datetime value's parts. |
| DateTime.ToText | Returns a textual representation of the datetime value. |
| #datetime | Creates a datetime value from year, month, day, hour, minute, and second. |