What is overriddencreatedon and why am I saying this?
Because so many customers are unaware of this so let’s change that
When loading data into dataverse (Common data service based on CDM or Dynamics 365 or Dynamics CRM or Xrm , ooo so many🙉).
Each entity (table) has a attribute called overriddencreatedon, when you populate this value especially through data migration activities, this value will override the “createdon” attribute on load into the dataverse database and populate “createdon” with the “overriddencreatedon” value. Its a built in feature of the platform.
cool right? 😉
If you don’t use this overridden field on create of these records and instead populate just the createdon, it won’t work, it will set it to the current time and date on running of the ETL / ELT process.
Conclusion 🐒
Conclusion Monkey says:
“Load data successfully and you have a happy customer for a day. Teach a customer how to do data import themselves, and you’ll have a happy customer for a lifetime”