Skip to content

Number Interpretation Variables

Number interpretation variables are system defined, that is, they are automatically generated according to the current regional settings of the operating system when a new app is created. The variables are included at the top of the script of the new app and substitute operating system defaults for certain number formatting settings at the time of the script execution. They can be deleted, edited or duplicated freely.

BrokenWeeks

The setting defines if weeks are broken or not.

BrokenWeeks

By default, functions use unbroken weeks. This means that:

  • In some years, week 1 starts in December, and in other years, week 52 or 53 continues into January.
  • Week 1 always has at least 4 days in January.

The alternative is to use broken weeks.

  • Week 52 or 53 do not continue into January.
  • Week 1 starts on January 1 and is, in most cases, not a full week.

The following values can be used:

  • 0 (=use unbroken weeks)
  • 1 (= use broken weeks)

Examples:

Set BrokenWeeks=0; //(use unbroken weeks)
Set BrokenWeeks=1; //(use broken weeks)

DateFormat

The format defined replaces the date format of the operating system (regional settings).

DateFormat

Example:

Set DateFormat='M/D/YY'; //(US format)
Set DateFormat='DD/MM/YY'; //(UK date format)
Set DateFormat='YYYY-MM-DD'; //(ISO date format)

DayNames

The format defined replaces the weekday names convention of the operating system (regional settings).

DayNames

Set DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

DecimalSep

The decimal separator defined replaces the decimal symbol of the operating system (regional settings).

DecimalSep

Examples:

Set DecimalSep='.';
Set DecimalSep=',';

FirstWeekDay

Integer that defines which day to use as the first day of the week.

FirstWeekDay

By default, functions use Monday as the first day of the week. The following values can be used:

  • 0 (= Monday)
  • 1 (= Tuesday)
  • 2 (= Wednesday)
  • 3 (= Thursday)
  • 4 (= Friday)
  • 5 (= Saturday)
  • 6 (= Sunday)

Example:

Set FirstWeekDay=6; //(set Sunday as the first day of the week)

LongDayNames

The format defined replaces the long weekday names convention of the operating system (regional settings).

LongDayNames

Example:

Set LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';

LongMonthNames

The format defined replaces the long month names convention of the operating system (regional settings).

LongMonthNames

Example

Set LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

MoneyDecimalSep

The decimal separator defined replaces the decimal symbol for currency of the operating system (regional settings).

MoneyDecimalSep

Example:

Set MoneyDecimalSep='.';

MoneyFormat

The symbol defined replaces the currency symbol of the operating system (regional settings).

MoneyFormat

Example:

Set MoneyFormat='$ #,##0.00; ($ #,##0.00)';

MoneyThousandSep

The thousands separator defined replaces the digit grouping symbol for currency of the operating system (regional settings).

MoneyThousandSep

Example:

Set MoneyThousandSep=',';

MonthNames

The format defined replaces the month names convention of the operating system (regional settings).

MonthNames

Example:

Set MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

NumericalAbbreviation

The numerical abbreviation sets which abbreviation to use for scale prefixes of numerals, for example M for mega or a million (106), and µ for micro (10-6).

NumericalAbbreviation

You set the NumericalAbbreviation variable to a string containing a list of abbreviation definition pairs, delimited by semi colon. Each abbreviation definition pair should contain the scale (the exponent in decimal base) and the abbreviation separated by a colon, for example, 6:M for a million.

The default setting is '3:k;6:M;9:G;12:T;15:P;18:E;21:Z;24:Y;-3:m;-6:µ;-9:n;-12:p;-15:f;-18:a;-21:z;-24:y'

Examples:

This setting will change the prefix for a thousand to t and the prefix for a billion to B. This would be useful for financial applications where you would expect abbreviations like t$, M$, and B$.

Set NumericalAbbreviation='3:t;6:M;9:B;12:T;15:P;18:E;21:Z;24:Y;-3:m;-6:µ;-9:n;-12:p;-15:f;-18:a;-21:z;-24:y';

ReferenceDay

The setting defines which day in January to set as reference day to define week 1.

ReferenceDay

By default, functions use 4 as the reference day. This means that week 1 must contain January 4, or put differently, that week 1 must always have at least 4 days in January.

The following values can be used to set a different reference day:

  • 1 (= January 1)
  • 2 (= January 2)
  • 3 (= January 3)
  • 4 (= January 4)
  • 5 (= January 5)
  • 6 (= January 6)
  • 7 (= January 7)

Example:

Set ReferenceDay=3; //(set January 3 as the reference day)

ThousandSep

The thousands separator defined replaces the digit grouping symbol of the operating system (regional settings).

ThousandSep

Examples:

Set ThousandSep=','; //(for example, seven billion must be specified as: 7,000,000,000)
Set ThousandSep=' ';

TimeFormat

The format defined replaces the time format of the operating system (regional settings).

TimeFormat

Example:

Set TimeFormat='hh:mm:ss';

TimestampFormat

The format defined replaces the date and time formats of the operating system (regional settings).

TimestampFormat

Example:

Set TimestampFormat='M/D/YY hh:mm:ss[.fff]';