Studio has ten reserved variables which are read-only. These variables are not actual variables, but simply key words used in the same context as you would a variable. The values that these key words return can vary depending on when/how you use them. Many are designed to return information about the current date and/or time.
| Variable Name | Description |
|---|---|
| timezoneid | Returns the ID of the current time zone. This is either set at the business unitFile format associated with Microsoft Excel; may also be expressed as .xlsx level or using the TIMEZONE script action. |
| timezoneoffset | Returns the offset from UTC based on the current time zone and the current time and date. This value is in hours. |
| now |
Returns the current date and time based on the current time zone. [String expression] Formats the date/time in the standard date and time format which is MM/dd/yyyy h:mm:ss tt. [Numeric expression] Returns the date/time as an OLE automation date/time. |
| date |
Returns the current date based on the current time zone. [String expression] Formats the date in the standard date format which is MM/dd/yyyy. [Numeric expression] Returns the date as an OLE automation date/time without the fractional portion. |
| time |
Returns the current time based on the current time zone. [String expression] Formats the time in the standard date format which is h:mm:ss tt. [Numeric expression] Returns the time as an OLE automation date/time with only the fractional portion. |
| gmt |
Returns the current Coordinated Universal date and time. [String expression] Formats the date/time in the standard RFC 1123 format which is “ddd, dd MMM yyyy HH:mm:ss GMT”. Example: “Mon, 03 Oct 2009 13:35:14 GMT”. [Numeric expression] Returns the date/time as an OLE automation date/time. See also utc. |
| utc |
Returns the current Coordinated Universal date and time. [String expression] Formats the date/time in the standard date and time format which is MM/dd/yyyy h:mm:ss tt. [Numeric expression] Returns the date/time as an OLE automation date/time. |
| timestamp |
Returns the number of 100-nanosecond intervalsA period between points, limits, or events, such as dates or times. that have elapsed since 12:00:00 midnight, January 1, 0001 UTC. This can be used as an ever increasing number – guaranteed to be unique across time. It is a very large number of at least 18 digits. [String expression] Returns the full 18+ digit number representing the current UTC timestamp. [Numeric expression] Returns a double precision (64-bit) floating point representation of the current UTC timestamp. The floating point value will be slightly less precise than the string representation. Examples of timestamps: Numeric: 6.33911474194624E+17 String: 633911474194623828 |
| dow | Day of Week. Returns the ordinal value for the current day of week based on the current time zone where Sunday is 0. |
| weekday | Returns the unabbreviated string representation of the current week day based on the current time zone. This is only applicable within a string expression. |
