---
title: Transform Date Custom Value
slug: segment/transform-date-custom-value
docTags: 
createdAt: 2026-01-15T22:07:24.295Z
---

:::hint{type="info"}
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.

## Video overview

::embed[]{url="https://vimeo.com/694934002?fl=pl&fe=vl"}

## Create a Transform Date Custom Value

1. Under the **Custom Values** section, click the **Add new value** button.
2. Provide a name for the Custom Value, select *apply formula to a field* as **Type**, and click **Next**.
3. Select *Transform Date *as **Type of Formula** and click **Next.**

::Image[****]{src="https://support.deselect.com/hc/article_attachments/29448003717649" size="60" width="869" height="788" isUploading="false" darkWidth="869" darkHeight="788" showCaption="false"}

3. Select the Data Extension and the date field that you want to transform

::Image[]{src="https://support.deselect.com/hc/article_attachments/29448003728145" size="70" width="793" height="175" isUploading="false" darkWidth="793" darkHeight="175" showCaption="false"}

4. On **Add**, indicate the integer necessary and select the time unit via the dropdown list.

::Image[]{src="https://support.deselect.com/hc/article_attachments/29448026543761" size="60" width="793" height="223" isUploading="false" darkWidth="793" darkHeight="223" showCaption="false"}

:::Paragraph{listStyleType="disc" indent="2"}
To add a time unit, enter the value as is, e.g., 1.
:::

:::Paragraph{listStyleType="disc" indent="2"}
To subtract a time unit, use the (-) sign, e.g. -1.
:::

5. Select which format to use either **Date** and **Time **or only **Date**.

::Image[]{src="https://support.deselect.com/hc/article_attachments/29448003732881" size="60" width="803" height="268" isUploading="false" darkWidth="803" darkHeight="268" showCaption="false"}

6. 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.

::Image[]{src="https://support.deselect.com/hc/article_attachments/29448003735313" size="60" width="811" height="143" isUploading="false" darkWidth="811" darkHeight="143" showCaption="false"}

7. Save and move the new Custom Value to the Target Data Extension fields.