Transform Date Custom Value
This feature is available on Unaric Segment Plus and Advanced.
Transform Date Custom Value (also known as the DATEADD() in SQL) allows you to transform an existing date field by adding or subtracting DATEPART using signed integer +/- (e.g., the number of hours, days, weeks, months) and/or converting it into a different timezone.
This greatly helps in many scenarios such as creating call-to-action with an expiration date, generating new dates for reminder campaigns, etc.
To learn how to add a new field to your Target Data Extension that contains these Order Dates, but in a client's local timezone (e.g. CEST), see 25. Tranform date fields.
Video overview
Create a Transform Date Custom Value
- Under the Custom Values section, click the Add new value button.
- Provide a name for the Custom Value, select apply formula to a field as Type, and click Next.
- Select Transform Date as Type of Formula and click Next.
- Select the Data Extension and the date field that you want to transform
- On Add, indicate the integer necessary and select the time unit via the dropdown list.
- To add a time unit, enter the value as is, e.g., 1.
- To subtract a time unit, use the (-) sign, e.g. -1.
- Select which format to use either Date and Time or only Date.
- In case you want to transform the date field's timezone, turn on the Convert timezone toggle and choose the timezones accordingly: From which timezone you are converting (current timezone of the date field) and To which timezone you want to convert.
- Save and move the new Custom Value to the Target Data Extension fields.