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:

KindNotationLocation
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:

KindExampleData 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:

  1. A default variable @TaskId@. It replaces this parameter by the actual value at execution time.

  2. 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

  3. Report parameter @Transaction Number@. It replaces this parameter by the actual value at execution time.

  4. 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)

  5. 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)

385

Ad-hoc execution with variable recipient email

842

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

NameDescriptionData 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 TypeNameCommentArguments
Int32BitAndBitwise AND operator.Int32 A: First operand. Int32 B: Second operand.
Int32BitOrBitwise OR operator.Int32 A: First operand. Int32 B: Second operand.
Int32BitXorBitwise XOR (Exclusive Or) operator.Int32 A: First operand. Int32 B: Second operand.

Conversion Functions

Return TypeNameCommentArguments
StringToStringConverts a DateTime value to a string using the local machine date time format.DateTime Value
StringToStringConverts 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
StringToStringConverts an Integer value to string using the local machine number formatInt32 Value: The Integer value to convert.
StringToStringConverts a floating point number to a string using the local machine number format.Double Value: The floating point number to convert.
StringToStringConverts a Boolean value to a string using the string values 'True' or 'False'.Boolean Value: The Boolean value to convert.
DateTimeToDateTimeConverts 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.
DateTimeToDateTimeConverts a string to a DateTime using the local machine date time format.String Value: The String value to convert.
DateTimeToDateTimeConverts a string to a DateTime using a custom format.String Value: The String value to convert. String Format: The format of Value.
Int32ToIntConverts a dateTime value to an Integer.DateTime Value: The dateTime value to convert.
Int32ToIntConverts a floating point Double value to Integer by rounding off the decimals.Double Value: The double value to convert.
Int32ToIntConverts a Boolean value to an integer, where True is translated to 1 and False is translated to 0.Boolean Value:
Int32ToIntConverts 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.
DoubleToDoubleConverts an Integer value to a double.Int32 Value:
DoubleToDoubleConverts a DateTime value to a Double. The return value is an OLE Automation (OA) date time, as used e.g. by Excel.DateTime Value:
DoubleToDoubleParses a string to a floating point Double value using local number format as set in regional options on the machine.String Value:
StringToStringConverts a DateTime value to a string using the local machine date time format.DateTime Value:
DateTimeToDateTimeConverts a string to a DateTime using the local machine date time format.String Value: The String value to convert.
Int32ToIntConverts a floating point Double value to Integer by rounding off the decimals.Double Value: The double value to convert.
DoubleToDoubleParses a string to a floating point Double value using local number format as set in regional options on the machine.String Value:
BooleanToBooleanCasts 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.
StringToStringConverts 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.
StringToStringConverts 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 TypeNameCommentArguments
Int32YearReturns the year component of the supplied DateTime.DateTime Value: The DateTime to operate on.
Int32MonthReturns the month number of the supplied DateTime.DateTime Value: The DateTime to operate on.
Int32DayReturns the day of month number of the supplied DateTime.DateTime Value: The DateTime to operate on.
Int32HourReturns the hour component of the supplied DateTime.DateTime Value: The DateTime to operate on.
Int32MinuteReturns the minute component of the supplied DateTime.DateTime Value: The DateTime to operate on.
Int32SecondReturns the second component of the supplied DateTime.DateTime Value: The DateTime to operate on.
DateTimeDateGets 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.
StringWeekDayReturns 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:
Int32DayOfYearReturns the day-of-year specified by the supplied DateTime.DateTime Value: The DateTime to operate on.
DateTimeAddDaysAdds 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.
DateTimeAddMonthsAdds 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.
DateTimeAddYearsAdds a number of years to the supplied DateTime value.DateTime Value: The DateTime to operate on. Int32 Count: The number of years to add.
DateTimeAddWeekDaysAdds 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.
DateTimeFirstWeekDayOfMonthReturns 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.
DateTimeLastWeekDayOfMonthReturns 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.
DateTimeNowGets the current date and time.
DateTimeWeekOfYearReturns the week number of the year using the current cultureDateTime Value: The DateTime to operate on.
DateTimeWeekOfYearReturns the week number of the year using a specific cultureDateTime Value: The DateTime to operate on. String Culture: The culture code ex : en-US, fr-FR, sv-SE
DateTimeChangeTimeZoneChanges 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"
DateTimeDateCreates 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).
DateTimeLastDayOfMonthGets the last day of the month which Date is in.Date: The origin date.
DateTimeLastDayOfPreviousMonthGets the last day of the month prior to that which Date is in.Date: The origin date.
DateTimeFirstDayOfMonthGets the first of the month which Date is in.Date: The origin date.
DateTimeFirstDayOfPreviousMonthGets the first of the month prior to that which Date is in.Date: The origin date.

List Functions

Return TypeNameCommentArguments
Int32CountReturns the number of elements in the list.Object[] List: The list to count elements in.
BooleanContainsDetermines 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[]AppendAppends an element at the end of a list.Object[] List: The list to add the element to. Object Element: The element to add.
Object[]RemoveRemoves all occurences of an element value from a list.Object[] List: The list to remove elements from., Object Element: The element value to remove.
ObjectElementGets 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[]ListCreates a new, empty list.
Int32IndexOfReturns 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[]RemoveAtRemoves 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[]InsertInserts 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[]ReplaceAtReplaces 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.
ObjectElementAtGets 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.
ObjectElementAtReturns 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 TypeNameCommentArguments
DoubleIfThenElseIf 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.
DoubleIfIf 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.
DateTimeIfThenElseIf 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.
DateTimeIfIf 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.
Int32IfThenElseIf 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.
Int32IfIf 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.
StringIfThenElseIf 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.
StringIfIf 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.
StringTryCatchTry-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.
StringTryTry-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.
DoubleTryCatchTry-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.
DoubleTryTry-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.
Int32TryCatchTry-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.
Int32TryTry-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.
BooleanTryCatchTry-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.
BooleanTryTry-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.
DateTimeTryCatchTry-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.
DateTimeTryTry-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.
BooleanIsNullDetermines 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 TypeNameCommentArguments
DoubleAbsReturns the absolute value of a floating point Double method.Double Value: A signed floating point number
DoubleModReturns modulus of the two floating point numbers.Double A: Double B:
DoubleAcosReturns arc cosine of Value.Double Value: A signed floating point Double.
DoubleAsinReturns the arc sine of ValueDouble Value: A signed floating point Double.
DoubleAtanReturns the arc tangent of ValueDouble Value: A signed floating point Double.
DoubleCosReturns cosine of ValueDouble Value: A signed floating point Double.
DoubleCoshReturns hyperbolic cosine of ValueDouble Value: A signed floating point Double.
DoubleExpReturns E raised to the power of ValueDouble Value: A signed floating point Double.
DoubleSinReturns the sine of ValueDouble Value: A signed floating point Double.
DoubleSinhReturns the hyperbolic sine of ValueDouble Value: A signed floating point Double.
DoubleSqrtReturns the square root of ValueDouble Value: A signed floating point Double.
DoubleTanReturns the tangent of ValueDouble Value: A signed floating point Double.
DoubleTanhReturns the hyperbolic tangent of ValueDouble Value: A signed floating point Double.
DoubleLogReturns the logarithm of ValueDouble Value: A signed floating point Double.
DoubleMinReturns the smaller of two numbers.Double A: A signed floating point Double. Double B: A signed floating point Double.
DoubleMaxReturns the larger of two numbers.Double A: A signed floating point Double. Double B: A signed floating point Double.
DoublePowReturns the specified number raised to the specified power.Double A: A signed floating point Double. Double B: A signed floating point Double.
DoubleRoundReturns 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.
Int32FloorReturns the largest integer less than or equal to the double value.Double Value: The double value to convert.
Int32CeilingReturns the smallest integer greater than or equal to the double value.Double Value: The double value to convert.
Int32TruncateReturn the integral part of the double value.Double Value: The double value to convert.

String Functions

Return TypeNameCommentArguments
StringLeftReturns 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.
StringRightReturns 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. Int32LengthReturns the length in characters of the substring.String Value: The string to measure.
StringSubstringReturns 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.
StringMidReturns 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.
StringUpperReturns an upper case copy of the argument string.String Value: The string to upcase.
StringLowerReturns a lower case copy of the argument string.String Value: The string to downcase.
StringTrimRemoves all occurrences of white space characters from the beginning and end of the string.String Value: The string to trim.
BooleanMatchSearches 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.
BooleanMSearches 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.
StringSubstituteSubstitutes 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.
StringSSubstitutes 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.
StringSplitSplits 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[]SplitSplits 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.
BooleanIsNullOrEmptyDetermines whether the input string is null or an empty string.String Input: The input.
BooleanIsNullOrWhiteSpaceDetermines 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 IDDisplay 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