Transform Date Custom Value

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 +/ (eg the number of hours, days, weeks, months) and/or converting it into a different timezone this greatly helps in many scenarios and challenges eg creating call to action with an expiration date, generating new dates for reminder campaigns, etc watch this video to learn more about transform date custom value how to create a transform date custom value? go to custom values section > add new value button provide a name for the custom value > apply formula to a field > click next > transform date > click next select the data extension and the date field that you want to transform under 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, eg 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 7\ save and drag and drop the new custom value to the target data extension fields scenario you have a data extension (orders) that contains a column with order dates and you want 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) follow these https //support deselect com/hc/en us/articles/360011786957 to achieve this you can also create reusable custom values follow this link to learn https //support deselect com/hc/en us/search/click?data=bah7djohawrskwgrqi9%2fjgo6d2fjy291bnrfawrpa8uyktojdhlwzukidgfydgljbgugogzfvdoidxjsssjxahr0chm6ly9zdxbwb3j0lmrlc2vszwn0lmnvbs9oyy9lbi11cy9hcnrpy2xlcy8xmte2mdq1odg2nte2os1dyw4tss1yzxvzzs1tes1ddxn0b20tvmfsdwvzlwlulwfues1tzwxly3rpb24tbjsivdooc2vhcmnox2lkssipzjhlmdrhzwityjk3ns00zjm1lwfiytgtytm5mtk4ngfkmdnhbjsirjojcmfua2kgogtsb2nhbgvjigplbi11cwy7cfq6cnf1zxj5ssiry3vzdg9tihzhbhvlbjsivdoscmvzdwx0c19jb3vudglb 8d89b0696ecc8e9fbc9296d7434db1983a4f6f07