Notifications
Announcements
No record found.
Hello to everyoneI want to ask if someone knows if it is possible to change the format of the fields WHEN a data entity is exported to csv.For example, dates are always exported as utcDateTime (2007-01-02 08:00:00) and I want to change the format to yyyymmdd.
P.S. I want to do it automatically in data entity export. Not manually after the csv will be created.Thank you.
Hi SGbron,
There is no configuration option to change the date/time to a date only format. You can consider a virtual column which will return the date in your preferred format. This is a development effort.
Hello Andre, thanks for your reply
I read the documentation and some posts in community about Computed and Virtual fields.
docs.microsoft.com/.../data-entity-computed-columns-virtual-fields
I tried this example with the virtual field but for my case with the different format in utcDateTime.
So I create a new unmapped field "EntryDate" in the extension of my Employees Entity. I crete a new class and I add postLoad method.
public void postLoad() { next postLoad(); System.DateTime startDate = this.StartDate; this.EmployeeEntryDate = startDate.ToString('yyyymmdd'); }
But it is not even shown in the fields of Empoyees Entity in DMF when I am going to map it.
My bad...
The reason that the field was not visible was the staging table. I had to add it there.
But the solution is not correct.
The field is coming blank... :(
Have you updated the data entity list and/or regenerated the field mappings of this entity?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 559 Most Valuable Professional
André Arnaud de Cal... 464 Super User 2025 Season 2
Sohaib Cheema 250 User Group Leader
