Anaplan Data Orchestrator Functions: Comprehensive
Study Guide With Correct Solutions
ABS - Numeric Function Right Ans - ABS(number)
Returns the absolute value of a number. The absolute value of zero or a
positive number remains the same. The absolute value of a negative number is
the same number without the negative sign (the positive version).
ADDDAYS - Time and Date Function Right Ans - ADDDAYS(date, number)
Increments a date by a specified number of days.
ADDHOURS - Time and Date Function Right Ans -
ADDHOURS(date/datatime, number)
Increments a date or datatime by a specified number of hours.
ADDMINUTES - Time and Date Function Right Ans -
ADDMINUTES(date/datatime, number)
Increments a date or datatime by a specified number of minutes.
ADDMONTHS - Time and Date Function Right Ans -
ADDMONTHS(date/datatime, number)
Increments a date by a specified number of months.
ADDSECONDS - Time and Date Function Right Ans -
ADDSECONDS(date/datatime, number)
Increments a date or datatime by a specified number of seconds.
ADDYEARS - Time and Date Function Right Ans - ADDYEARS(date,number)
Increments a date by a specified number of years.
CAST - Miscellaneous Function Right Ans - CAST(expression, dms_type)
Converts a value (expression) into a specified data type (except 'string'). Can
also be used to convert string-type columns to other data types. The format
must be a standard format, such as MM/DD/YYYY.
CEILING - Numeric Function Right Ans - CEILING(number)
Rounds up the number to the next whole number.
, CURRENTDATE - Time and Date Function Right Ans - CURRENTDATE()
Returns the current date. The start time of when the transform is executed is
in Universal Time Coordinated (UTC).
CURRENTTIMESTAMP - Time and Date Function Right Ans -
CURRENTTIMESTAMP()
Returns the current date and time. The start time of when the transform is
executed is in Universal Time Coordinated (UTC).
DATE - Time and Date Function Right Ans - DATE(year, month, day)
Returns a DATE value in year-month-day format.
DAY - Time and Date Function Right Ans - DAY(date)
Returns the value of the day from a date input. The value is between 1 and 31.
DAYSINMONTH - Time and Date Function Right Ans -
DAYSINMONTH(year, month)
Returns the number of days in the year and month you specify.
DIVIDE - Numeric Function Right Ans - DIVIDE(number, divider)
Divides one number by another.
EXP - Numeric Function Right Ans - EXP(number)
Raises the mathematical constant e, or Euler's number, to the power you
specify.
FIND - Text Function Right Ans - FIND(text to find, text to search)
Searches for the first occurrence of a text value within another one. If the text
contains the specified characters, the function returns a number. This number
indicates the position of the first occurrence of the text value searched for.
FLOOR - Numeric Function Right Ans - FLOOR(number)
Rounds down the number to the previous whole number.
HASH - Miscellaneous Function Right Ans - HASH(text)
Returns the SHA-224 value of the text string. The value is unique and 56
characters.
HOUR - Time and Date Function Right Ans - HOUR(timestamp)
Study Guide With Correct Solutions
ABS - Numeric Function Right Ans - ABS(number)
Returns the absolute value of a number. The absolute value of zero or a
positive number remains the same. The absolute value of a negative number is
the same number without the negative sign (the positive version).
ADDDAYS - Time and Date Function Right Ans - ADDDAYS(date, number)
Increments a date by a specified number of days.
ADDHOURS - Time and Date Function Right Ans -
ADDHOURS(date/datatime, number)
Increments a date or datatime by a specified number of hours.
ADDMINUTES - Time and Date Function Right Ans -
ADDMINUTES(date/datatime, number)
Increments a date or datatime by a specified number of minutes.
ADDMONTHS - Time and Date Function Right Ans -
ADDMONTHS(date/datatime, number)
Increments a date by a specified number of months.
ADDSECONDS - Time and Date Function Right Ans -
ADDSECONDS(date/datatime, number)
Increments a date or datatime by a specified number of seconds.
ADDYEARS - Time and Date Function Right Ans - ADDYEARS(date,number)
Increments a date by a specified number of years.
CAST - Miscellaneous Function Right Ans - CAST(expression, dms_type)
Converts a value (expression) into a specified data type (except 'string'). Can
also be used to convert string-type columns to other data types. The format
must be a standard format, such as MM/DD/YYYY.
CEILING - Numeric Function Right Ans - CEILING(number)
Rounds up the number to the next whole number.
, CURRENTDATE - Time and Date Function Right Ans - CURRENTDATE()
Returns the current date. The start time of when the transform is executed is
in Universal Time Coordinated (UTC).
CURRENTTIMESTAMP - Time and Date Function Right Ans -
CURRENTTIMESTAMP()
Returns the current date and time. The start time of when the transform is
executed is in Universal Time Coordinated (UTC).
DATE - Time and Date Function Right Ans - DATE(year, month, day)
Returns a DATE value in year-month-day format.
DAY - Time and Date Function Right Ans - DAY(date)
Returns the value of the day from a date input. The value is between 1 and 31.
DAYSINMONTH - Time and Date Function Right Ans -
DAYSINMONTH(year, month)
Returns the number of days in the year and month you specify.
DIVIDE - Numeric Function Right Ans - DIVIDE(number, divider)
Divides one number by another.
EXP - Numeric Function Right Ans - EXP(number)
Raises the mathematical constant e, or Euler's number, to the power you
specify.
FIND - Text Function Right Ans - FIND(text to find, text to search)
Searches for the first occurrence of a text value within another one. If the text
contains the specified characters, the function returns a number. This number
indicates the position of the first occurrence of the text value searched for.
FLOOR - Numeric Function Right Ans - FLOOR(number)
Rounds down the number to the previous whole number.
HASH - Miscellaneous Function Right Ans - HASH(text)
Returns the SHA-224 value of the text string. The value is unique and 56
characters.
HOUR - Time and Date Function Right Ans - HOUR(timestamp)
