DateTime functions

  • Article

These functions create and manipulate datetime and datetimezone values.

Name Description
DateTime.AddZone Adds timezone information to the datetime 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 Creates a datetime from local and universal datetime formats.
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.
#datetime Creates a datetime value from year, month, day, hour, minute, and second.