Date and time functions

The table below contains a short description of each script function. For information about syntax, examples, etc., see the full description of each script function.

Function name	Description
DayOfWeek	Returns the number of the day in a week. Monday returns 1 and Sunday returns 7.
DayOfYear	Returns the number of the day in a year (1-365) where 1 is January 1st.
Dformat	Formats a date according to the specified date format. If the date is invalid, no formatting is done, and an empty string is returned.
DiffDate	Calculates the number of days between two dates.
DtisoFormat	Converts date and time to ISO 8601 format. ("YYYY-MM-DDTHH:MM:SS"). The StreamStudio Collector web application requires this date and time format.
GetDate	Returns the system date in the format yyyymmdd.
GetDateTime	Returns the system date and time in the format specified by the given picture clause, or in ISO format including milliseconds if empty string is given as argument.
GetTime	Returns the system time in the format hhmmss (24-hour time format).
GetUTCDateTime	Returns date and time in ISO8601 format (including milliseconds) taking daylight saving time into account.
IsDate	Checks if a string expression is a date string.
NewDate	Calculates a date from a given date and a negative or positive number of days.
WeekOfYear	Returns the year and the number of a week within the year.