I have created a DE and I want to default the current date value to one of the date field .

When I try doing its not allowing me to create the DE, it gives error. Is there any way we can do the same ?

Thanks and Regards, Anumol Antony

  • Can you post a screenshot of the error and your DE structure? The default date in DE doesn’t usually throw any errors, so this could be something else. Do you create your DE from an existing DE? – zuzannamj Aug 6 '19 at 5:53
  • Do you have the rights to create DataExtensions? – Johannes Schapdick Aug 6 '19 at 6:14

Here's how you add a field in DE with default current date:

  1. create a field and set the type to date
  2. click on the "-" icon next to Default Value field

That's it!

enter image description here

  • Thank you for answering this :) – Anumol Aug 7 '19 at 5:40
  • No problem - if it helped, please mark the answer as accepted :-) – zuzannamj Aug 7 '19 at 5:41
  • I'd like to add that you need to set the date field to nullable as well so your automation isn't required to write a date and the default (today's date) is written. – Vincent Ammirato Oct 8 '19 at 12:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.