Mapping Manager - @DATEADD() Function

How to use the @DATEADD() function

Micah A. Parker avatar
Written by Micah A. Parker
Updated over a week ago

Product: Mapping Manager

Article Link: http://help.truecommerce.com/en/articles/6701152-mapping-manager-dateadd-function

@DATEADD(Token,DaysToAdd)
Token: Date Token to modify
DaysToAdd: How many +/- days to Add/Subtract from Date Token
return: Modified Date

Modifies a given Date by adding or subtracting days to it

Examples

Add 3 days to current date

@DATEADD([T:SPECIAL_TOKEN_CURRENT_DATE],3)

Subtract 1 day from Requested Delivery

@DATEADD([T:DATE_REQUESTED_DELIVERY],-1)

Weekdays, Weekends, and Holidays

The DATEADD() function does not support logic that is dependent on specific days of the week, it has no ability to check if there is a weekend, or holiday, or any other other calendar based date. It can only add or subtract from the given date.

rev 11/2/22

Did this answer your question?