Absolute Get the absolute value of given number abs(number)
Formula Sample abs({{Discount Points Total Amount}})
Example Input: abs(-70) -> Output: 70
Parameters
number (NUMBER): Number to convert to absolute value
Add time Adds the given time to the base time, controlled by the provided unit add_time(base, timeToAdd, unit)
Formula Sample add_time({{TRID Date}}, 5, 'day')
Example Input: add_time('03-13-2026', 5, 'day') -> Output: '03-18-2026'
Parameters
base (DATE): Starting date
timeToAdd (NUMBER): Amount of time to add
unit (STRING): Unit of time to add, must be from 'day', 'week', or 'month'
Concatenate Combine between 2 and 100 string values concatenate(string1, string2, ...stringN?)
Formula Sample concatenate('Applied product is', ' ', {{Product Name}})
Example Input: concatenate('Applied product is', ' ', 'CONF CONV 30 Year Fixed') -> Output: 'Applied product is CONF CONV 30 Year Fixed'
Parameters
string (STRING): Strings to combine together
Contains Determine if a string is found within a piece of text (case insensitive by default) contains(textToSearch, searchFor, caseSensitive)
Formula Sample contains({{Product Name}}, '30 year fixed', false)
Example Input: contains('CONF CONV 30 Year Fixed', '30 year fixed', false) -> Output: true
Parameters
textToSearch (STRING): Text to look inside
searchFor (STRING): Text to search for
caseSensitive (BOOLEAN): Whether to match case (optional, defaults to false)
Date before another date To check if date is before another date date_before_date(dateX, dateY)
Formula Sample date_before_date({{TRID Date}}, {{Pre-Approved Date}})
Example Input: date_before_date('03-13-2026', '03-14-2026') -> Output: true
Parameters
dateX (DATE): Date to compare
dateY (DATE): Date to compare against
Date atleast X days before another date To check if date is atleast 'X' days before another date date_AtleastXDaysBefore_date(dateX, dateY, days, dayType)
Formula Sample date_AtleastXDaysBefore_date({{TRID Date}}, {{Pre-Approved Date}}, 5, 'calendarDay')
Example Input: date_AtleastXDaysBefore_date('03-13-2026', '03-18-2026', 5, 'calendarDay') -> Output: true
Parameters
dateX (DATE): Date to check
dateY (DATE): Reference date
days (NUMBER): Number of days
dayType (STRING): Type of days to count, must be from 'businessDay' or 'calendarDay'
Date atmost X days before another date To check if date is atmost 'X' days before another date date_AtmostXDaysBefore_date(dateX, dateY, days, dayType)
Formula Sample date_AtmostXDaysBefore_date({{TRID Date}}, {{Pre-Approved Date}}, 10, 'calendarDay')
Example Input: date_AtmostXDaysBefore_date('03-13-2026', '03-18-2026', 10, 'calendarDay') -> Output: true
Parameters
dateX (DATE): Date to check
dateY (DATE): Reference date
days (NUMBER): Maximum number of days
dayType (STRING): Type of days to count, must be from 'businessDay' or 'calendarDay'
Date atleast X days after another date To check if date is atleast 'X' days after another date date_AtleastXDaysAfter_date(dateX, dateY, days, dayType)
Formula Sample date_AtleastXDaysAfter_date({{Pre-Approved Date}}, {{TRID Date}}, 5, 'calendarDay')
Example Input: date_AtleastXDaysAfter_date('03-18-2026', '03-13-2026', 5, 'calendarDay') -> Output: true
Parameters
dateX (DATE): Date to check
dateY (DATE): Reference date
days (NUMBER): Number of days
dayType (STRING): Type of days to count, must be from 'businessDay' or 'calendarDay'
Date atmost X days after another date To check if date is atmost 'X' days after another date date_AtmostXDaysAfter_date(dateX, dateY, days, dayType)
Formula Sample date_AtmostXDaysAfter_date({{Pre-Approved Date}}, {{TRID Date}}, 10, 'calendarDay')
Example Input: date_AtmostXDaysAfter_date('03-18-2026', '03-13-2026', 10, 'calendarDay') -> Output: true
Parameters
dateX (DATE): Date to check
dateY (DATE): Reference date
days (NUMBER): Maximum number of days
dayType (STRING): Type of days to count, must be from 'businessDay' or 'calendarDay'
Date same as another date To check if a date is same as another date date_sameAs_date(dateX, dateY)
Formula Sample date_sameAs_date({{TRID Date}}, {{Pre-Approved Date}})
Example Input: date_sameAs_date('03-13-2026', '03-13-2026') -> Output: true
Parameters
dateX (DATE): First date
dateY (DATE): Second date
Date after another date To check if date is after another date date_after_date(dateX, dateY)
Formula Sample date_after_date({{Pre-Approved Date}}, {{TRID Date}})
Example Input: date_after_date('03-14-2026', '03-13-2026') -> Output: true
Parameters
dateX (DATE): Date to check
dateY (DATE): Reference date
Max of multiple dates To get maximum of multiple dates max_date(date1, date2, ...dateN?)
Formula Sample max_date({{TRID Date}}, {{Pre-Approved Date}}, {{Qualification Date}})
Example Input: max_date('03-13-2026', '03-14-2026', '03-15-2026') -> Output: '03-15-2026'
Parameters
date (DATE): Dates to find the latest from
Min of multiple dates To get minimum of multiple dates min_date(date1, date2, ...dateN?)
Formula Sample min_date({{TRID Date}}, {{Pre-Approved Date}}, {{Qualification Date}})
Example Input: min_date('03-13-2026', '03-14-2026', '03-15-2026') -> Output: '03-13-2026'
Parameters
date (DATE): Dates to find the earliest from
Start boundry of current date To get start boundary of the current day, week, or month based on the specified unit start_of(unit)
Formula Sample start_of('month')
Example Input: start_of('month') -> Output: '03-01-2026'
Parameters
unit (STRING): Time unit to get start of, must be from 'day', 'week', or 'month'
End boundry of current date To get end boundary of the current day, week, or month based on the specified unit end_of(unit)
Formula Sample end_of('month')
Example Input: end_of('month') -> Output: '03-31-2026'
Parameters
unit (STRING): Time unit to get end of, must be from 'day', 'week', or 'month'
Date atleast X days in past To check if provided date is atleast X days before today date_AtleastXDaysIn_Past(date, days, dayType)
Formula Sample date_AtleastXDaysIn_Past({{TRID Date}}, 5, 'calendarDay')
Example Input: date_AtleastXDaysIn_Past('03-07-2026', 5, 'calendarDay') -> Output: true
Parameters
date (DATE): Date to check
days (NUMBER): Minimum number of days
dayType (STRING): Type of days to count, must be from 'businessDay' or 'calendarDay'
Date atleast X days in future To check if provided date is atleast X days after today date_AtleastXDaysIn_Future(date, days, dayType)
Formula Sample date_AtleastXDaysIn_Future({{Pre-Approved Date}}, 5, 'calendarDay')
Example Input: date_AtleastXDaysIn_Future('03-19-2026', 5, 'calendarDay') -> Output: true
Parameters
date (DATE): Date to check
days (NUMBER): Minimum number of days
dayType (STRING): Type of days to count, must be from 'businessDay' or 'calendarDay'
Date atmost X days in past To check if provided date is atmost X days before today date_AtmostXDaysIn_Past(date, days, dayType)
Formula Sample date_AtmostXDaysIn_Past({{TRID Date}}, 10, 'calendarDay')
Example Input: date_AtmostXDaysIn_Past('03-04-2026', 10, 'calendarDay') -> Output: true
Parameters
date (DATE): Date to check
days (NUMBER): Maximum number of days
dayType (STRING): Type of days to count, must be from 'businessDay' or 'calendarDay'
Date atmost X days in future To check if provided date is atmost X days after today date_AtmostXDaysIn_Future(date, days, dayType)
Formula Sample date_AtmostXDaysIn_Future({{Pre-Approved Date}}, 10, 'calendarDay')
Example Input: date_AtmostXDaysIn_Future('03-22-2026', 10, 'calendarDay') -> Output: true
Parameters
date (DATE): Date to check
days (NUMBER): Maximum number of days
dayType (STRING): Type of days to count, must be from 'businessDay' or 'calendarDay'
Today To get today's date today()
Formula Sample today()
Example Input: today() -> Output: '03-13-2026'
Date To get custom date based on input's date(MM, DD, YYYY)
Formula Sample date(03, 13, 2026)
Example Input: date(03, 13, 2026) -> Output: '03-13-2026'
Parameters
MM (NUMBER): Month
DD (NUMBER): Day
YYYY (NUMBER): Year
Number same as other number comparing two number fields for equality number_sameAs_number(numberA, numberB)
Formula Sample number_sameAs_number({{Base Loan Amount}}, {{Total Loan Amount}})
Example Input: number_sameAs_number(500000, 500000) -> Output: true
Parameters
numberA (NUMBER): First number
numberB (NUMBER): Second number
Max of multiple numbers To get maximum of multiple numbers max_number(number1, number2, ...numberN?)
Formula Sample max_number({{Base Loan Amount}}, {{Total Loan Amount}}, {{Purchase Price}})
Example Input: max_number(500000, 750000, 600000) -> Output: 750000
Parameters
number (NUMBER): Numbers to find the highest value
Min of multiple numbers To get minimum of multiple numbers min_number(number1, number2, ...numberN?)
Formula Sample min_number({{Base Loan Amount}}, {{Total Loan Amount}}, {{Purchase Price}})
Example Input: min_number(500000, 750000, 600000) -> Output: 500000
Parameters
number (NUMBER): Numbers to find the lowest value