Export Data from Dataverse Table (CSV) DateTime Column returned as Text in CSV

[Anonymous]

I have been exporting data from a dataverse table and a datetime column in Excel is a different data type. Some records are being returned as text and other records as Dates. (Using top tab on dataverse table, Data>Export Data)

I have noticed that if the day value in the Date is greater than 12, then the record is returned as Text field in the CSV. If the day value in the Date is less than 13 then the record is returned as Date field in the CSV.

My local time is UK, Does anyone else experience this issue with exporting date time data from dataverse table?

Is it a configuration setting error?

System Settings for Dynamics 365 and current format English (United Kingdom).

Thanks

[Z_Lukowski]

@Anonymous 

Hey, I understand the error which occured here,

Your data type is saved as mm-dd-yyyy instead of dd-mm-yyyy and if it encounter 13 in mm part it fails (there is no month after december) and therefore saves the data as Text. I do not know tho how to fix this issue, maybe try to download all the data as text and fix afterwards in Excel changing Text to Date with correct format dd-mm-yyyy

Also check your properly saved Dates I bet months are switched with days, be cautious or you'll corrupt your data here,

BR

Zbigniew

[Anonymous]

Thanks Zbigniew, sorry for the slow reply.

Yes you have understood the issue, I am not sure how I can change in Dataverse the format of how the date are stored to dd-mm-yyyy.

In the Advanced Settings - > System Settings -> Formats. It is currently configured as English (United Kingdom) format.

Do you know any other places that I could look for the Date Format? 

Do you know if in Dataverse can it only be stored as mm-dd-yyyy?

Thanks,

Oli