Timestamp Custom Value

timestamp custom value also known as the getdate() in sql allows you to create a new field and add the timestamp as the value it can be converted to a specific timezone of your choice watch this video to learn more about timestamp custom value how to create a timestamp 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 > timestamp > click next choose the format on how you want the timestamp to appear either including both date and time or only time optionally, convert the timestamp to a specific timezone save and drag and drop the new custom value to the target data extension fields scenario you have a data extension (contacts) with contacts that you want to add to an existing list of contacts when you add the new contacts you also want to add the date each record was added to the list at the local timezone to which they belong (e g cest) follow these https //support deselect com/hc/en us/articles/360011914858 23 how can i add a timestamp to my data 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