Variables & Functions
Reports can utilize variables and functions to create dynamic parameters, names and references.
Variable Usage
Variables are available for export file name, mail template.
There are 5 kinds of variables to use, default variables, customs variables, references to the result report, report parameters and formulas. This means that the values can be fetched from different part of the report settings.
To use any of those variables follow the notations:
| Kind | Notation | Location |
|---|---|---|
| Default variables | @Default Variable Name@ | See table below |
| Custom | @Custom Variable Key@ | Settings\Variable Settings |
| Report References | @<Sheet name>!<Cell name>@ | Report Worksheet |
| Report parameters | @Report Parameter Name@ | Task Details\iterations, Report |
| Formulas | {=Formula} |
To use variables in the formulas please follow the notations:
| Kind | Example | Data Type |
|---|---|---|
| Default variables | {=@Default Variable Name@} | See table below |
| Custom variables | {=@Custom Variable Key@} | String |
| Report References | {=@<Sheet name>!<Cell name>@} | String |
| Report parameters | {=$Report Parameter Name$} | Refer to the report |
Examples
Mail Layout (Report detail\Layout)
A simple email template that utilizes different types of variables and functions can be seen below:
Task Id: @TaskId@
Local due date: {=ToString(ChangeTimeZone (@DueDate@, "UTC", "W. Europe Standard Time"), "yyyy-MM-dd HH:mm")}
Transaction number: @Transaction Number@
Market ID Instrument ID Issuer ID Currency ID
@Transaction!A1@ @Transaction!B1@ @Transaction!C1@ @Transaction!D1@
@Transaction!A2@ @Transaction!B2@ @Transaction!C2@ @Transaction!D2@
You can access the file: @COMMON FOLDER PATH@
The above template has five dynamic fields:
-
A default variable @TaskId@. It replaces this parameter by the actual value at execution time.
-
Formula - It calculates the value and replace the formula by its result.
ToString -Function to change a date to string
"yyyy-MM-dd HH:mm" -Format of the string
ChangeTimeZone -Function to change the time zone of a date
@DueDate@ - Default parameter
UTC - Time zone of the input date
W. Europe Standard Time - Time zone of the output date -
Report parameter @Transaction Number@. It replaces this parameter by the actual value at execution time.
-
Reference to the report @Transaction!A1@. It replaces the reference by the actual value contained in the report at execution time (Sheet "Transaction", Cell A1)
-
Custom parameter @COMMON FOLDER PATH@. It replaces the parameter by the actual value when executed.
Export file name (Task detail\Export)
Files that are scheduled can be exported to disk. The folder and file name can be dynamic utilizing for example default and report parameters.
E.g.: @Facility Name@\Report @DueDate@ for a PDF export might yield a file "SKY-SUB\Report 2022-10-01.pdf if the report is executed on the Facility SKY-SUB.
Mail subject (Report details\Layout)
Mail subjects are defined in the Report Details for a specific Layout. The subject can be dynamic like:
@TaskName@ results - @DueDate@ - Parameter: @Transaction Number@
Mail To (Task details\Mails and Execute Report\To)
Ad-hoc execution with variable recipient email
Scheduled task with variable recipient email
Tip
To get reference in the right format the following formula can be used in Excel, making it possible to copy and paste into Word.
=CONCATENATE("@";ADDRESS(ROW();COLUMN();4;TRUE;"SheetName");"@")
Default Variables
| Name | Description | Data Type |
|---|---|---|
| @DueDate@ | The log due date. | DateTime |
| @DueDateTime@ | The log due date-time. | DateTime |
| @StartDate@ | The log start date and time. | DateTime |
| @EndDate@ | The log end date and time. | DateTime |
| @Duration@ | The duration for the execution. | DateTime |
| @FailedInState@ | If the task fails it will show the where it failed. | String |
| @Error@ | Displays an error message if the task fails. | String |
| @TaskName@ | The task name. | String |
| @TaskId@ | The task id. Can be used to create a link to the task details page, like: http://HOST/TaskDetails?Id=@TaskId@ | Integer |
| @SourceName@ @ReportName@ | The source name, report or endpoint. | String |
| @SourceId@ @ReportId@ | The source id, report or endpoint. Can be used to create a link to the report log or details page, like: http://HOST/DocumentLog?DocumentId=@ReportId@ | Integer |
| @SourceComment@ @ReportComment@ | The source comment, report or endpoint. | String |
| @ReportDescription@ | The report description. | String |
| @ScheduleName@ | The schedule name. | String |
| @ScheduleId@ | The schedule id. Can be used to link to the schedule configuration page, like: http://HOST/Schedule/Edit/@ScheduleId@ | Integer |
| @TaskLogId@ | The task log id. Can be used to link to the task log page, like: http://HOST/TaskLog?Id=@TaskLogId@ | Integer |
| @UserName@ | The username used during execution. | String |
| @<Parameter>@ | Report parameters can be used by referencing the parameter name. For a parameter, Start Date, it would be @Start Date@ | Refer to the report |
Function Reference
Bitwise Functions
| Return Type | Name | Comment | Arguments |
|---|---|---|---|
| Int32 | BitAnd | Bitwise AND operator. | Int32 A: First operand. Int32 B: Second operand. |
| Int32 | BitOr | Bitwise OR operator. | Int32 A: First operand. Int32 B: Second operand. |
| Int32 | BitXor | Bitwise XOR (Exclusive Or) operator. | Int32 A: First operand. Int32 B: Second operand. |
Conversion Functions
| Return Type | Name | Comment | Arguments |
|---|---|---|---|
| String | ToString | Converts a DateTime value to a string using the local machine date time format. | DateTime Value |
| String | ToString | Converts a DateTime to a string using a custom date time format specified as a string. This covers also cases where you want only a specific portion of the date, such as the year or the year and month. | DateTime Value and String Format |
| String | ToString | Converts an Integer value to string using the local machine number format | Int32 Value: The Integer value to convert. |
| String | ToString | Converts a floating point number to a string using the local machine number format. | Double Value: The floating point number to convert. |
| String | ToString | Converts a Boolean value to a string using the string values 'True' or 'False'. | Boolean Value: The Boolean value to convert. |
| DateTime | ToDateTime | Converts a double to a date time. Value is expected to be an OLE Automation (OA) date, which is the format used internally by Excel. | Double Value: The OA double value to operate on. |
| DateTime | ToDateTime | Converts a string to a DateTime using the local machine date time format. | String Value: The String value to convert. |
| DateTime | ToDateTime | Converts a string to a DateTime using a custom format. | String Value: The String value to convert. String Format: The format of Value. |
| Int32 | ToInt | Converts a dateTime value to an Integer. | DateTime Value: The dateTime value to convert. |
| Int32 | ToInt | Converts a floating point Double value to Integer by rounding off the decimals. | Double Value: The double value to convert. |
| Int32 | ToInt | Converts a Boolean value to an integer, where True is translated to 1 and False is translated to 0. | Boolean Value: |
| Int32 | ToInt | Converts a String to an Integer using neutral culture. | String Value: String value containing only numbers and possibly a minus sign to convert to an integer. |
| Double | ToDouble | Converts an Integer value to a double. | Int32 Value: |
| Double | ToDouble | Converts a DateTime value to a Double. The return value is an OLE Automation (OA) date time, as used e.g. by Excel. | DateTime Value: |
| Double | ToDouble | Parses a string to a floating point Double value using local number format as set in regional options on the machine. | String Value: |
| String | ToString | Converts a DateTime value to a string using the local machine date time format. | DateTime Value: |
| DateTime | ToDateTime | Converts a string to a DateTime using the local machine date time format. | String Value: The String value to convert. |
| Int32 | ToInt | Converts a floating point Double value to Integer by rounding off the decimals. | Double Value: The double value to convert. |
| Double | ToDouble | Parses a string to a floating point Double value using local number format as set in regional options on the machine. | String Value: |
| Boolean | ToBoolean | Casts an object reference to a Boolean value, to a Boolean reference. This function doesn't affect the underlying value. If the underlying value isn't a Boolean, the method will throw an InvalidCastException. | Object Value: The object value to cast. |
| String | ToString | Converts a list to string. The output string is formatted as a comma separated list of element values in the list. | Object[] List: The list to convert to string. |
| String | ToString | Converts a list to string, using the specified element separator. | Object[] List: The list to convert to string, String Separator: The element separator. |
DateTime Functions
| Return Type | Name | Comment | Arguments |
|---|---|---|---|
| Int32 | Year | Returns the year component of the supplied DateTime. | DateTime Value: The DateTime to operate on. |
| Int32 | Month | Returns the month number of the supplied DateTime. | DateTime Value: The DateTime to operate on. |
| Int32 | Day | Returns the day of month number of the supplied DateTime. | DateTime Value: The DateTime to operate on. |
| Int32 | Hour | Returns the hour component of the supplied DateTime. | DateTime Value: The DateTime to operate on. |
| Int32 | Minute | Returns the minute component of the supplied DateTime. | DateTime Value: The DateTime to operate on. |
| Int32 | Second | Returns the second component of the supplied DateTime. | DateTime Value: The DateTime to operate on. |
| DateTime | Date | Gets a date with the same date as the argument, and the time value set to 12:00:00 midnight (00:00:00). | DateTime Value: The DateTime to operate on. |
| String | WeekDay | Returns a string containing the name of the week day of the supplied DateTime value. The names of the days are en-US culture specific. | DateTime Value: |
| Int32 | DayOfYear | Returns the day-of-year specified by the supplied DateTime. | DateTime Value: The DateTime to operate on. |
| DateTime | AddDays | Adds a number of days to the supplied DateTime value. The number of days is a floating point number where the decimal represents a fraction of a day. | DateTime Value: The DateTime to operate on. Double Count: The floating point number of days to add. |
| DateTime | AddMonths | Adds a number of months to the supplied DateTime value. | DateTime Value: The DateTime to operate on. Int32 Count: The number of whole months to add. |
| DateTime | AddYears | Adds a number of years to the supplied DateTime value. | DateTime Value: The DateTime to operate on. Int32 Count: The number of years to add. |
| DateTime | AddWeekDays | Adds a number of week days to the supplied DateTime structure. Week days are Monday-Friday. Friday + 1 week day yields monday. | DateTime Value: The DateTime to operate on. Int32 Count: The number of week days to add. |
| DateTime | FirstWeekDayOfMonth | Returns the first week day of the month specified by the supplied DateTime value. Week days are Monday-Friday. | DateTime Value: The DateTime to operate on. |
| DateTime | LastWeekDayOfMonth | Returns the last week day of the month specified by the supplied DateTime value. Week days are Monday-Friday. | DateTime Value: The DateTime to operate on. |
| DateTime | Now | Gets the current date and time. | |
| DateTime | WeekOfYear | Returns the week number of the year using the current culture | DateTime Value: The DateTime to operate on. |
| DateTime | WeekOfYear | Returns the week number of the year using a specific culture | DateTime Value: The DateTime to operate on. String Culture: The culture code ex : en-US, fr-FR, sv-SE |
| DateTime | ChangeTimeZone | Changes the time zone of a DateTime value. | DateTime Value: The DateTime to operate on. String TimeZoneFrom: The current time zone of the value, e.g. "UTC", "Pacific Standard Time", "W. Europe Standard Time" , String TimeZoneTo: The time zone to convert the value to, e.g. "UTC", "Pacific Standard Time", "W. Europe Standard Time" |
| DateTime | Date | Creates a new DateTime from year, month and day components. | Year: The year of the date. Month: The month of the date (Optional). Day: The date in month (Optional). |
| DateTime | LastDayOfMonth | Gets the last day of the month which Date is in. | Date: The origin date. |
| DateTime | LastDayOfPreviousMonth | Gets the last day of the month prior to that which Date is in. | Date: The origin date. |
| DateTime | FirstDayOfMonth | Gets the first of the month which Date is in. | Date: The origin date. |
| DateTime | FirstDayOfPreviousMonth | Gets the first of the month prior to that which Date is in. | Date: The origin date. |
List Functions
| Return Type | Name | Comment | Arguments |
|---|---|---|---|
| Int32 | Count | Returns the number of elements in the list. | Object[] List: The list to count elements in. |
| Boolean | Contains | Determines whether a list contains a specific element. This also covers the case when you want to check for null elements. | Object[] List: The list to inspect, Object Element: The sought element. |
| Object[] | Append | Appends an element at the end of a list. | Object[] List: The list to add the element to. Object Element: The element to add. |
| Object[] | Remove | Removes all occurences of an element value from a list. | Object[] List: The list to remove elements from., Object Element: The element value to remove. |
| Object | Element | Gets an element from a list by value. If the element doesn't exist the function returns null. | Object[] List: The list. Object Element: The element. |
| Object[] | List | Creates a new, empty list. | |
| Int32 | IndexOf | Returns the position of the first element in a list that is equal to the specified element. Returns -1 if no element is equal to the specified element. The specified element can also be null, returning the position of the first null element in the list. | Object[] List: The list to search. Object Element: The element to search for. |
| Object[] | RemoveAt | Removes an element from a list at the specified 0-indexed position. Specifying a position outside of the bounds of the list causes an exception. | Object[] List: The list to remove an element from. Int32 Index: The position of the element to remove. |
| Object[] | Insert | Inserts a specified value into a specified position in a list. Specifying a position outside of the bounds of the list causes an exception. | Object[] List: The list to insert into. Object Value: The element value to insert. Int32 Index: The position to insert at. |
| Object[] | ReplaceAt | Replaces the element at the specified 0-indexed position in a list. Specifying a position outside of the bounds of the list causes an exception. | Object[] List: The list. Object Value: The replacement element value. Int32 Index: The position to replace. |
| Object | ElementAt | Gets the element at a specified 0-indexed position of a list. Specifying a position outside of the bounds of the list causes an exception. | Object[] List: The list , Int32 Index: The position of the element to get. |
| Object | ElementAt | Returns the element at a specified 0-indexed position in a list, or the specified default value if the element position does not exist in the list or the element at position is null. | Object[] List: The list to get the element from. Int32 Index: The position of the element to get. Object DefaultValue: The default value. |
Logical Functions
| Return Type | Name | Comment | Arguments |
|---|---|---|---|
| Double | IfThenElse | If statement. If the boolean expression evaluates to true, the value first of the two optional statements are returned, otherwise the value of the second optional expression is returned. | Boolean Expression: A logical (Boolean) expression. Double WhenTrue: An expression to run when the logical expression evaluates to true. Double WhenFalse: An expression to run when the logical expression evaluates to false. |
| Double | If | If statement. If the boolean expression evaluates to true, the value first of the two optional statements are returned, otherwise the value of the second optional expression is returned. | Boolean Expression: A logical (Boolean) expression. Double WhenTrue: An expression to run when the logical expression evaluates to true. Double WhenFalse: An expression to run when the logical expression evaluates to false. |
| DateTime | IfThenElse | If statement. If the boolean expression evaluates to true, the value first of the two optional statements are returned, otherwise the value of the second optional expression is returned. | Boolean Expression: A logical (Boolean) expression. DateTime WhenTrue: An expression to run when the logical expression evaluates to true. DateTime WhenFalse: An expression to run when the logical expression evaluates to false. |
| DateTime | If | If statement. If the boolean expression evaluates to true, the value first of the two optional statements are returned, otherwise the value of the second optional expression is returned. | Boolean Expression: A logical (Boolean) expression. DateTime WhenTrue: An expression to run when the logical expression evaluates to true. DateTime WhenFalse: An expression to run when the logical expression evaluates to false. |
| Int32 | IfThenElse | If statement. If the boolean expression evaluates to true, the value first of the two optional statements are returned, otherwise the value of the second optional expression is returned. | Boolean Expression: A logical (Boolean) expression. Int32 WhenTrue: An expression to run when the logical expression evaluates to true. Int32 WhenFalse: An expression to run when the logical expression evaluates to false. |
| Int32 | If | If statement. If the boolean expression evaluates to true, the value first of the two optional statements are returned, otherwise the value of the second optional expression is returned. | Boolean Expression: A logical (Boolean) expression. mInt32 WhenTrue: An expression to run when the logical expression evaluates to true. Int32 WhenFalse: An expression to run when the logical expression evaluates to false. |
| String | IfThenElse | If statement. If the boolean expression evaluates to true, the value first of the two optional statements are returned, otherwise the value of the second optional expression is returned. | Boolean Expression: A logical (Boolean) expression. String WhenTrue: An expression to run when the logical expression evaluates to true. String WhenFalse: An expression to run when the logical expression evaluates to false. |
| String | If | If statement. If the boolean expression evaluates to true, the value first of the two optional statements are returned, otherwise the value of the second optional expression is returned. | Boolean Expression: A logical (Boolean) expression. String WhenTrue: An expression to run when the logical expression evaluates to true. String WhenFalse: An expression to run when the logical expression evaluates to false. |
| String | TryCatch | Try-Catch statement. If Try evaluates without error its value is returned, if Try evaluates with errors, the Catch statements is evaluated returned. (This is particularly useful when converting columns to a different data type where some of the elements of the column is empty.) | String Try: An expression to attempt to evaluate. String Catch: Evaluated and returned if the Try expression could not be returned. |
| String | Try | Try-Catch statement. If Try evaluates without error its value is returned, if Try evaluates with errors, the Catch statements is evaluated returned. (This is particularly useful when converting columns to a different data type where some of the elements of the column is empty.) | String Try: An expression to attempt to evaluate. String Catch: Evaluated and returned if the Try expression could not be returned. |
| Double | TryCatch | Try-Catch statement. If Try evaluates without error its value is returned, if Try evaluates with errors, the Catch statements is evaluated returned. (This is particularly useful when converting columns to a different data type where some of the elements of the column is empty.) | Double Try: An expression to attempt to evaluate. Double Catch: Evaluated and returned if the Try expression could not be returned. |
| Double | Try | Try-Catch statement. If Try evaluates without error its value is returned, if Try evaluates with errors, the Catch statements is evaluated returned. (This is particularly useful when converting columns to a different data type where some of the elements of the column is empty.) | Double Try: An expression to attempt to evaluate. Double Catch: Evaluated and returned if the Try expression could not be returned. |
| Int32 | TryCatch | Try-Catch statement. If Try evaluates without error its value is returned, if Try evaluates with errors, the Catch statements is evaluated returned. (This is particularly useful when converting columns to a different data type where some of the elements of the column is empty.) | Int32 Try: An expression to attempt to evaluate. Int32 Catch: Evaluated and returned if the Try expression could not be returned. |
| Int32 | Try | Try-Catch statement. If Try evaluates without error its value is returned, if Try evaluates with errors, the Catch statements is evaluated returned. (This is particularly useful when converting columns to a different data type where some of the elements of the column is empty.) | Int32 Try: An expression to attempt to evaluate. Int32 Catch: Evaluated and returned if the Try expression could not be returned. |
| Boolean | TryCatch | Try-Catch statement. If Try evaluates without error its value is returned, if Try evaluates with errors, the Catch statements is evaluated returned. (This is particularly useful when converting columns to a different data type where some of the elements of the column is empty.) | Boolean Try: An expression to attempt to evaluate. Boolean Catch: Evaluated and returned if the Try expression could not be returned. |
| Boolean | Try | Try-Catch statement. If Try evaluates without error its value is returned, if Try evaluates with errors, the Catch statements is evaluated returned. (This is particularly useful when converting columns to a different data type where some of the elements of the column is empty.) | Boolean Try: An expression to attempt to evaluate. Boolean Catch: Evaluated and returned if the Try expression could not be returned. |
| DateTime | TryCatch | Try-Catch statement. If Try evaluates without error its value is returned, if Try evaluates with errors, the Catch statements is evaluated returned. (This is particularly useful when converting columns to a different data type where some of the elements of the column is empty.) | DateTime Try: An expression to attempt to evaluate. DateTime Catch: Evaluated and returned if the Try expression could not be returned. |
| DateTime | Try | Try-Catch statement. If Try evaluates without error its value is returned, if Try evaluates with errors, the Catch statements is evaluated returned. (This is particularly useful when converting columns to a different data type where some of the elements of the column is empty.) | DateTime Try: An expression to attempt to evaluate. DateTime Catch: Evaluated and returned if the Try expression could not be returned. |
| Boolean | IsNull | Determines whether the argument value is null. A special case is that when the test object is string 'NULL', the method returns TRUE too. | Object A: The object to test. |
Mathematical Functions
| Return Type | Name | Comment | Arguments |
|---|---|---|---|
| Double | Abs | Returns the absolute value of a floating point Double method. | Double Value: A signed floating point number |
| Double | Mod | Returns modulus of the two floating point numbers. | Double A: Double B: |
| Double | Acos | Returns arc cosine of Value. | Double Value: A signed floating point Double. |
| Double | Asin | Returns the arc sine of Value | Double Value: A signed floating point Double. |
| Double | Atan | Returns the arc tangent of Value | Double Value: A signed floating point Double. |
| Double | Cos | Returns cosine of Value | Double Value: A signed floating point Double. |
| Double | Cosh | Returns hyperbolic cosine of Value | Double Value: A signed floating point Double. |
| Double | Exp | Returns E raised to the power of Value | Double Value: A signed floating point Double. |
| Double | Sin | Returns the sine of Value | Double Value: A signed floating point Double. |
| Double | Sinh | Returns the hyperbolic sine of Value | Double Value: A signed floating point Double. |
| Double | Sqrt | Returns the square root of Value | Double Value: A signed floating point Double. |
| Double | Tan | Returns the tangent of Value | Double Value: A signed floating point Double. |
| Double | Tanh | Returns the hyperbolic tangent of Value | Double Value: A signed floating point Double. |
| Double | Log | Returns the logarithm of Value | Double Value: A signed floating point Double. |
| Double | Min | Returns the smaller of two numbers. | Double A: A signed floating point Double. Double B: A signed floating point Double. |
| Double | Max | Returns the larger of two numbers. | Double A: A signed floating point Double. Double B: A signed floating point Double. |
| Double | Pow | Returns the specified number raised to the specified power. | Double A: A signed floating point Double. Double B: A signed floating point Double. |
| Double | Round | Returns the decimal number rounded to a specified precision using the Banker's Rounding method. | Double A: A signed floating point Double. Int32 B: An unsigned Integer number (0 to 15) specifying the precision. |
| Int32 | Floor | Returns the largest integer less than or equal to the double value. | Double Value: The double value to convert. |
| Int32 | Ceiling | Returns the smallest integer greater than or equal to the double value. | Double Value: The double value to convert. |
| Int32 | Truncate | Return the integral part of the double value. | Double Value: The double value to convert. |
String Functions
| Return Type | Name | Comment | Arguments | |||
|---|---|---|---|---|---|---|
| String | Left | Returns a substring of the string Count characters from the beginning of the string. | String Value: The string to substring. Int32 Count: The number of characters to substring. | |||
| String | Right | Returns a substring of the string Count characters from the end of the string. | String Value: The string to substring. Int32 Count: The number of characters to substring. Int32 | Length | Returns the length in characters of the substring. | String Value: The string to measure. |
| String | Substring | Returns a substring from the argument string. | String Value: The string to substring. Int32 Start: The 0-indexed start position of the substring. Int32 Count: The number of characters to substring. | |||
| String | Mid | Returns a substring from the argument string. | String Value: The string to substring. Int32 Start: The 0-indexed start position of the substring. Int32 Count: The number of characters to substring. | |||
| String | Upper | Returns an upper case copy of the argument string. | String Value: The string to upcase. | |||
| String | Lower | Returns a lower case copy of the argument string. | String Value: The string to downcase. | |||
| String | Trim | Removes all occurrences of white space characters from the beginning and end of the string. | String Value: The string to trim. | |||
| Boolean | Match | Searches the input string for occurrence of the pattern, returning a Boolean indicating whether at least one match was found. | String Input: The input string to search. String Pattern: The regular expression pattern to match. | |||
| Boolean | M | Searches the input string for occurrence of the pattern, returning a Boolean indicating whether at least one match was found. | String Input: The input string to search. String Pattern: The regular expression pattern to match. | |||
| String | Substitute | Substitutes all occurrences of Pattern in the string with supplied substitute. | String Input: The input string to search. String Pattern: The pattern to match. String Substitute: The substitution string to replace Pattern with in the input string. | |||
| String | S | Substitutes all occurrences of Pattern in the string with supplied substitute. | String Input: The input string to search. String Pattern: The pattern to match. String Substitute: The substitution string to replace Pattern with in the input string. | |||
| String | Split | Splits a string into parts based on a separator, returning a specific element from the split determined by Index. Empty entries are not removed, so if Separator occurrs back-to-back they will yield empty elements.. | String Input: Input string to split. String Separator: Separator to split by. Int32 Index: 0-based index of the element to return. If Index is out of bounds, an 'NULL' value is returned. The separator is not included in the output value. | |||
| Object[] | Split | Splits the input string into elements by the specified separator. Returns a list with the individual elements. | String Input: The input string.String Separator: The element separator to split by. | |||
| Boolean | IsNullOrEmpty | Determines whether the input string is null or an empty string. | String Input: The input. | |||
| Boolean | IsNullOrWhiteSpace | Determines whether the input string is null, an empty string, or a string containing only empty values. | String Input: The input. |
Common Time Zones
This appendix contains a list of time zones available for use with the ChangeTimeZone function.
| Time Zone ID | Display String |
|---|---|
| Dateline Standard Time | (UTC-12:00) International Date Line West |
| UTC-11 | (UTC-11:00) Coordinated Universal Time-11 |
| Aleutian Standard Time | (UTC-10:00) Aleutian Islands |
| Hawaiian Standard Time | (UTC-10:00) Hawaii |
| Marquesas Standard Time | (UTC-09:30) Marquesas Islands |
| Alaskan Standard Time | (UTC-09:00) Alaska |
| UTC-09 | (UTC-09:00) Coordinated Universal Time-09 |
| Pacific Standard Time (Mexico) | (UTC-08:00) Baja California |
| UTC-08 | (UTC-08:00) Coordinated Universal Time-08 |
| Pacific Standard Time | (UTC-08:00) Pacific Time (US & Canada) |
| US Mountain Standard Time | (UTC-07:00) Arizona |
| Mountain Standard Time (Mexico) | (UTC-07:00) Chihuahua, La Paz, Mazatlan |
| Mountain Standard Time | (UTC-07:00) Mountain Time (US & Canada) |
| Central America Standard Time | (UTC-06:00) Central America |
| Central Standard Time | (UTC-06:00) Central Time (US & Canada) |
| Easter Island Standard Time | (UTC-06:00) Easter Island |
| Central Standard Time (Mexico) | (UTC-06:00) Guadalajara, Mexico City, Monterrey |
| Canada Central Standard Time | (UTC-06:00) Saskatchewan |
| SA Pacific Standard Time | (UTC-05:00) Bogota, Lima, Quito, Rio Branco |
| Eastern Standard Time (Mexico) | (UTC-05:00) Chetumal |
| Eastern Standard Time | (UTC-05:00) Eastern Time (US & Canada) |
| Haiti Standard Time | (UTC-05:00) Haiti |
| Cuba Standard Time | (UTC-05:00) Havana |
| US Eastern Standard Time | (UTC-05:00) Indiana (East) |
| Turks And Caicos Standard Time | (UTC-05:00) Turks and Caicos |
| Paraguay Standard Time | (UTC-04:00) Asuncion |
| Atlantic Standard Time | (UTC-04:00) Atlantic Time (Canada) |
| Venezuela Standard Time | (UTC-04:00) Caracas |
| Central Brazilian Standard Time | (UTC-04:00) Cuiaba |
| SA Western Standard Time | (UTC-04:00) Georgetown, La Paz, Manaus, San Juan |
| Pacific SA Standard Time | (UTC-04:00) Santiago |
| Newfoundland Standard Time | (UTC-03:30) Newfoundland |
| Tocantins Standard Time | (UTC-03:00) Araguaina |
| E. South America Standard Time | (UTC-03:00) Brasilia |
| SA Eastern Standard Time | (UTC-03:00) Cayenne, Fortaleza |
| Argentina Standard Time | (UTC-03:00) City of Buenos Aires |
| Greenland Standard Time | (UTC-03:00) Greenland |
| Montevideo Standard Time | (UTC-03:00) Montevideo |
| Magallanes Standard Time | (UTC-03:00) Punta Arenas |
| Saint Pierre Standard Time | (UTC-03:00) Saint Pierre and Miquelon |
| Bahia Standard Time | (UTC-03:00) Salvador |
| UTC-02 | (UTC-02:00) Coordinated Universal Time-02 |
| Mid-Atlantic Standard Time | (UTC-02:00) Mid-Atlantic - Old |
| Azores Standard Time | (UTC-01:00) Azores |
| Cape Verde Standard Time | (UTC-01:00) Cabo Verde Is. |
| UTC | (UTC) Coordinated Universal Time |
| GMT Standard Time | (UTC+00:00) Dublin, Edinburgh, Lisbon, London |
| Greenwich Standard Time | (UTC+00:00) Monrovia, Reykjavik |
| Sao Tome Standard Time | (UTC+00:00) Sao Tome |
| Morocco Standard Time | (UTC+01:00) Casablanca |
| W. Europe Standard Time | (UTC+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna |
| Central Europe Standard Time | (UTC+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague |
| Romance Standard Time | (UTC+01:00) Brussels, Copenhagen, Madrid, Paris |
| Central European Standard Time | (UTC+01:00) Sarajevo, Skopje, Warsaw, Zagreb |
| W. Central Africa Standard Time | (UTC+01:00) West Central Africa |
| Jordan Standard Time | (UTC+02:00) Amman |
| GTB Standard Time | (UTC+02:00) Athens, Bucharest |
| Middle East Standard Time | (UTC+02:00) Beirut |
| Egypt Standard Time | (UTC+02:00) Cairo |
| E. Europe Standard Time | (UTC+02:00) Chisinau |
| Syria Standard Time | (UTC+02:00) Damascus |
| West Bank Standard Time | (UTC+02:00) Gaza, Hebron |
| South Africa Standard Time | (UTC+02:00) Harare, Pretoria |
| FLE Standard Time | (UTC+02:00) Helsinki, Kyiv, Riga, Sofia, Tallinn, Vilnius |
| Israel Standard Time | (UTC+02:00) Jerusalem |
| Kaliningrad Standard Time | (UTC+02:00) Kaliningrad |
| Sudan Standard Time | (UTC+02:00) Khartoum |
| Libya Standard Time | (UTC+02:00) Tripoli |
| Namibia Standard Time | (UTC+02:00) Windhoek |
| Arabic Standard Time | (UTC+03:00) Baghdad |
| Turkey Standard Time | (UTC+03:00) Istanbul |
| Arab Standard Time | (UTC+03:00) Kuwait, Riyadh |
| Belarus Standard Time | (UTC+03:00) Minsk |
| Russian Standard Time | (UTC+03:00) Moscow, St. Petersburg |
| E. Africa Standard Time | (UTC+03:00) Nairobi |
| Iran Standard Time | (UTC+03:30) Tehran |
| Arabian Standard Time | (UTC+04:00) Abu Dhabi, Muscat |
| Astrakhan Standard Time | (UTC+04:00) Astrakhan, Ulyanovsk |
| Azerbaijan Standard Time | (UTC+04:00) Baku |
| Russia Time Zone 3 | (UTC+04:00) Izhevsk, Samara |
| Mauritius Standard Time | (UTC+04:00) Port Louis |
| Saratov Standard Time | (UTC+04:00) Saratov |
| Georgian Standard Time | (UTC+04:00) Tbilisi |
| Volgograd Standard Time | (UTC+04:00) Volgograd |
| Caucasus Standard Time | (UTC+04:00) Yerevan |
| Afghanistan Standard Time | (UTC+04:30) Kabul |
| West Asia Standard Time | (UTC+05:00) Ashgabat, Tashkent |
| Ekaterinburg Standard Time | (UTC+05:00) Ekaterinburg |
| Pakistan Standard Time | (UTC+05:00) Islamabad, Karachi |
| Qyzylorda Standard Time | (UTC+05:00) Qyzylorda |
| India Standard Time | (UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi |
| Sri Lanka Standard Time | (UTC+05:30) Sri Jayawardenepura |
| Nepal Standard Time | (UTC+05:45) Kathmandu |
| Central Asia Standard Time | (UTC+06:00) Astana |
| Bangladesh Standard Time | (UTC+06:00) Dhaka |
| Omsk Standard Time | (UTC+06:00) Omsk |
| Myanmar Standard Time | (UTC+06:30) Yangon (Rangoon) |
| SE Asia Standard Time | (UTC+07:00) Bangkok, Hanoi, Jakarta |
| Altai Standard Time | (UTC+07:00) Barnaul, Gorno-Altaysk |
| W. Mongolia Standard Time | (UTC+07:00) Hovd |
| North Asia Standard Time | (UTC+07:00) Krasnoyarsk |
| N. Central Asia Standard Time | (UTC+07:00) Novosibirsk |
| Tomsk Standard Time | (UTC+07:00) Tomsk |
| China Standard Time | (UTC+08:00) Beijing, Chongqing, Hong Kong, Urumqi |
| North Asia East Standard Time | (UTC+08:00) Irkutsk |
| Singapore Standard Time | (UTC+08:00) Kuala Lumpur, Singapore |
| W. Australia Standard Time | (UTC+08:00) Perth |
| Taipei Standard Time | (UTC+08:00) Taipei |
| Ulaanbaatar Standard Time | (UTC+08:00) Ulaanbaatar |
| Aus Central W. Standard Time | (UTC+08:45) Eucla |
| Transbaikal Standard Time | (UTC+09:00) Chita |
| Tokyo Standard Time | (UTC+09:00) Osaka, Sapporo, Tokyo |
| North Korea Standard Time | (UTC+09:00) Pyongyang |
| Korea Standard Time | (UTC+09:00) Seoul |
| Yakutsk Standard Time | (UTC+09:00) Yakutsk |
| Cen. Australia Standard Time | (UTC+09:30) Adelaide |
| AUS Central Standard Time | (UTC+09:30) Darwin |
| E. Australia Standard Time | (UTC+10:00) Brisbane |
| AUS Eastern Standard Time | (UTC+10:00) Canberra, Melbourne, Sydney |
| West Pacific Standard Time | (UTC+10:00) Guam, Port Moresby |
| Tasmania Standard Time | (UTC+10:00) Hobart |
| Vladivostok Standard Time | (UTC+10:00) Vladivostok |
| Lord Howe Standard Time | (UTC+10:30) Lord Howe Island |
| Bougainville Standard Time | (UTC+11:00) Bougainville Island |
| Russia Time Zone 10 | (UTC+11:00) Chokurdakh |
| Magadan Standard Time | (UTC+11:00) Magadan |
| Norfolk Standard Time | (UTC+11:00) Norfolk Island |
| Sakhalin Standard Time | (UTC+11:00) Sakhalin |
| Central Pacific Standard Time | (UTC+11:00) Solomon Is., New Caledonia |
| Russia Time Zone 11 | (UTC+12:00) Anadyr, Petropavlovsk-Kamchatsky |
| New Zealand Standard Time | (UTC+12:00) Auckland, Wellington |
| UTC+12 | (UTC+12:00) Coordinated Universal Time+12 |
| Fiji Standard Time | (UTC+12:00) Fiji |
| Kamchatka Standard Time | (UTC+12:00) Petropavlovsk-Kamchatsky - Old |
| Chatham Islands Standard Time | (UTC+12:45) Chatham Islands |
| UTC+13 | (UTC+13:00) Coordinated Universal Time+13 |
| Tonga Standard Time | (UTC+13:00) Nuku'alofa |
| Samoa Standard Time | (UTC+13:00) Samoa |
| Line Islands Standard Time | (UTC+14:00) Kiritimati Island |
Updated 4 months ago