Product: Mapping Manager
When working within Mapping Manager to modify your integration layer, you may encounter scenarios where you need to reference a specific piece of data that is not directly available from a transaction or your business system. Special Tokens are built-in tokens you can insert directly into your mapping formulas to reference these types of system-level values.
Token | Description |
[T:SPECIAL_TOKEN_COMMA] | Inserts a comma (,) — used since functions use commas to separate parameters, allowing a comma to be inserted into a value without breaking the function |
[T:SPECIAL_TOKEN_CR_LF] | Inserts a carriage return / line feed (CR LF) break |
[T:SPECIAL_TOKEN_CURRENT_DATE] | Populates the field with the current date at the time the mapping is processed |
[T:SPECIAL_TOKEN_CURRENT_TIME] | Populates the field with the current time at the time the mapping is processed |
Current Date — [T:SPECIAL_TOKEN_CURRENT_DATE]
The [T:SPECIAL_TOKEN_CURRENT_DATE] Special Token automatically populates a mapped field with today's date at the time the mapping is processed. This is useful when a field — such as a Ship Date, Order Date, or Due Date — needs to always reflect the current date without requiring manual entry.
To use this token, enter it directly into the mapping formula field for the desired definition in Mapping Manager:
[T:SPECIAL_TOKEN_CURRENT_DATE]
Using @DATEADD with the Current Date Token
The @DATEADD function can be combined with [T:SPECIAL_TOKEN_CURRENT_DATE] to calculate a date that is relative to today — for example, an estimated ship date 3 days from now, or a billing due date 30 days out.
Syntax
@DATEADD(DateToken, NumberOfDays)
Parameter | Description |
DateToken | The date value to offset. Accepts a Special Token or any mapped date field token. |
NumberOfDays | A whole number of days to offset. Use a positive number to add days forward, or a negative number to subtract days back. |
Examples
Add 3 days to the current date:
@DATEADD([T:SPECIAL_TOKEN_CURRENT_DATE], 3)
Subtract 7 days from the current date:
@DATEADD([T:SPECIAL_TOKEN_CURRENT_DATE], -7)
Add 30 days to the current date:
@DATEADD([T:SPECIAL_TOKEN_CURRENT_DATE], 30)
See Also
rev: 07/21/26