AMPscript Function Reference (Next)
The subset of AMPscript that Marketing Cloud Next supports — searchable and filterable, with the Core API version each function became available in and its Handlebars equivalent.
Marketing Cloud Next runs a subset of the AMPscript surface that Engagement offers. This page lists only the functions the catalog marks as available on Next, together with the Core API version they arrived in and the Handlebars helper that covers the same job.
The API version column comes from the language catalog that also powers the SFMC Language Service and the ESLint rules. The Verified badge, however, means a runtime sweep on a live Engagement CloudPage — those linked pages document Engagement behaviour and have not been re-run on Next. Treat them as a strong indication, not as proof for Next.
Supported functions
Verified means the function completed a runtime sweep on a live Engagement CloudPage and has a reference page — the name links to it. A name without the badge is listed from the language catalog and has not been proven here; use ampscript.guide for those until a sweep reaches them.
| Function | Category | API version | Returns | Description |
|---|---|---|---|---|
Add Verified
|
Math | 67 | number |
Computes the sum of two numeric values. |
BuildRowsetFromJSON
|
Content | 67 | rowset |
Parses a JSON string and returns a rowset. |
Concat Verified
|
String | 67 | string |
Concatenates two or more string values. |
ContentBlockByID
|
Content | 67 | string |
Retrieves and renders a Content Builder content block by its numeric ID. |
ContentBlockByKey
|
Content | 67 | string |
Retrieves and renders a Content Builder content block by its customer key. |
ContentBlockByName
|
Content | 67 | string |
Retrieves and renders a Content Builder content block by its folder path and name. |
DateAdd
|
Date and Time | 67 | date |
Adds a specified interval to a date value. |
DateDiff
|
Date and Time | 67 | number |
Returns the difference between two dates in the specified interval. |
DateParse
|
Date and Time | 67 | date |
Parses a date string into a date value. |
Divide Verified
|
Math | 67 | number |
Divides the first number by the second. |
Empty
|
Utility | 67 | boolean |
Returns true if the value is empty, null, or not defined. |
Field
|
Data Extension | 67 | string |
Retrieves the value of a specific field from a rowset row. |
Format
|
Utility | 67 | string |
Formats a value using a .NET format string. |
FormatCurrency
|
Utility | 67 | string |
Formats a number as a currency string. |
FormatDate
|
Date and Time | 67 | string |
Formats a date string according to the specified date and time format patterns. |
FormatNumber
|
Utility | 67 | string |
Formats a number using a format pattern. |
IIf
|
Utility | 67 | string |
Returns one of two values based on a boolean expression (inline if). |
IndexOf
|
String | 67 | number |
Returns the 1-based position of the first occurrence of a substring. |
IsNull
|
Utility | 67 | boolean |
Returns true if the value is null. |
Length Verified
|
String | 67 | number |
Returns the number of characters in a string. |
Lookup
|
Data Extension | 67 | string |
Returns a single field value from the first matching row in a data extension. |
Lowercase Verified
|
String | 67 | string |
Converts a string to all lowercase characters. |
Mod Verified
|
Math | 67 | number |
Returns the remainder after dividing the first number by the second (modulo). |
Multiply Verified
|
Math | 67 | number |
Computes the product of two numeric values. |
Now
|
Date and Time | 67 | date |
Returns the current system date and time (Central Time). Pass 1 to persist the value across renders. |
Output
|
Utility | 67 | void |
Writes a value to the rendered output. Used inside script blocks to emit content. |
OutputLine
|
Utility | 67 | void |
Writes a value followed by a line break to the rendered output. |
ProperCase
|
String | 67 | string |
Converts a string to proper (title) case, capitalizing the first letter of each word. |
RaiseError
|
Utility | 67 | void |
Raises a runtime error, optionally skipping the current subscriber or returning an API error. |
Random Verifieddiffers
|
Math | 67 | number |
Returns a random integer between the two specified values (inclusive). Both bounds must be whole numbers; a decimal bound aborts the page. The bounds may be supplied in either order. |
Replace
|
String | 67 | string |
Replaces all occurrences of a substring with a new value. |
ReplaceList
|
String | 67 | string |
Replaces multiple old values in a string with a single new value. |
RetrieveSalesforceObjects
|
Sales and Service Cloud | 67 | rowset |
Retrieves records from a connected Salesforce CRM object. |
Row
|
Data Extension | 67 | row |
Returns a specific row from a rowset by its 1-based index. |
RowCount
|
Data Extension | 67 | number |
Returns the number of rows in a rowset. |
StringToDate
|
Date and Time | 67 | date |
Converts a date string to a date value. |
Substring
|
String | 67 | string |
Extracts a portion of a string starting at the given index for the specified length. |
Subtract Verified
|
Math | 67 | number |
Computes the difference between two numeric values. |
Trim
|
String | 67 | string |
Removes leading and trailing whitespace from a string. |
Uppercase Verified
|
String | 67 | string |
Converts a string to all uppercase characters. The German sharp s remains unchanged rather than expanding to SS. |
v
|
Utility | 67 | string |
Short alias for retrieving a variable value inline. Equivalent to %%=v(@var)=%%. |
Related
- AMPscript and Handlebars — how the two languages sit side by side in a Next template
- Handlebars helper reference — the full helper catalog, including the ones with no AMPscript counterpart
- Differs from official docs (Next) — where runtime behaviour contradicts the official reference
- Full AMPscript catalog (Engagement) — every function, including the ones Next does not support