23. How can I add a timestamp to my data?

note the scenario below uses data from the deselect demo data package see docid 5 cozdtg0nwmlmeufrmbz 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) note this scenario uses the feature custom values, which is available in deselect plus and advanced 1\ input on the overview of the selection, click on create new to create a new selection drag data extension deselect demo contacts to the selected data extensions section 2\ output hit the create data extension button, enter a name, e g contacts target, and press save on the section on the left click on add all fields click save data extension now we're going to add a custom value under custom values on the left, click add new value under name, enter contact added and hit next choose type apply formula to a field choose type timestamp after this, a modal will pop up to do the settings under format , choose the format that you want to have either date and time, or only date in this case, select now to include both date and time switch the convert timezone toggle on under convert from timezone , by default is the cst (as this is what sfmc server uses) under convert to timezone , choose the timezone to which you want to convert your timestamp to, in this case, choose the central european standard time (cest) click save the logic defined above will, for each row, generate the current date and time and convert it to the central european standard time (cest) timezone now that the custom value contact added has been created, we can add it to the target data extension fields click on the tools > edit data extension drag and drop the contact added field to the target data extension fields click update target data extension > update 3\ preview when you click run preview on the preview screen, a results table will be shown with fields all fields from deselect demo contacts contact added, populated with the current date and time in the central european standard time (cest) timezone