Date Difference Custom Value

date difference custom value also known as the datediff() in sql allows you to calculate the difference between 2 date fields and express the difference into a specific time unit of your choice this can be a calculation between either; 2 existing date fields from a selected data extension a timestamp and an existing date field from a selected data extension (and vice versa) watch this video to learn more about date difference custom value how to create a date difference 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 > date difference > click next select either the date fields or the timestamp that you want to calculate select the time unit you want to express the difference in 5\ 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 calculates the number of days between the order date and the current date follow these step by step instructions https //support deselect com/hc/en us/articles/360011793257 24 calculate date difference to achieve this you can also create reusable custom values follow this link to learn how to create reusable custom values https //support deselect com/hc/en us/search/click?data=bah7djohawrskwgrqi9%2fjgo6d2fjy291bnrfawrpa8uyktojdhlwzukidgfydgljbgugogzfvdoidxjsssjxahr0chm6ly9zdxbwb3j0lmrlc2vszwn0lmnvbs9oyy9lbi11cy9hcnrpy2xlcy8xmte2mdq1odg2nte2os1dyw4tss1yzxvzzs1tes1ddxn0b20tvmfsdwvzlwlulwfues1tzwxly3rpb24tbjsivdooc2vhcmnox2lkssipzjhlmdrhzwityjk3ns00zjm1lwfiytgtytm5mtk4ngfkmdnhbjsirjojcmfua2kgogtsb2nhbgvjigplbi11cwy7cfq6cnf1zxj5ssiry3vzdg9tihzhbhvlbjsivdoscmvzdwx0c19jb3vudglb 8d89b0696ecc8e9fbc9296d7434db1983a4f6f07