Solved: Data Integration

Data Integration - Date formats

Hi,

I'm looking to integrate a Dynamics 365 CE environment with a Dynamics Unified Ops environment utilising the Data Integration platform within the PowerApps Admin Centre.

I have an issue with Date fields whereby they are interpreted incorrectly by Data Integration Projects.

In CE, I have a date field I wish to integrate. UK Date and Time formats are set environment wide. When viewing the Date in the Advanced Query and Filtering editor within Data Integration, the date is displayed in US format. After running the Project, to synchronise the data to Unified Ops (where UK formats are also set), the date is written in US formats whilst UK formats are being used by the environment.

e.g.

CE date UK format = 2nd January (02/01/2020)

AdvancedQ&F date US format = 2nd January (01/02/2020) - assuming this always formats in US date/time this would be correct

UOps date UK format= 1st February (01/02/2020) - the US date is written and not converted back to UK formatting

The strange thing is if I pass in a date that can only be interpreted in one way, the date is display correctly in Unified Ops:

e.g.

CE date UK format = 31st January (31/01/2020)

AdvancedQ&F date US format = 31st January (01/31/2020) - assuming this is US date/time this would be correct

UOps date UK format= 31st January (31/01/2020) - the correct date is displayed in UK format

I have tested the creation of a record in flow where I have more control over using ISO standard date formats, and the date is always imported correctly. Is there a way to specify what date format should be used in Data Integration - Advanced Query and Filtering? I notice there is a setting under "Global Options" called "Locale"; this is set to US. When attempting to change it to UK it always reverts to the original US setting automatically after saving the Project.

Quick Links

Subscribe to this forum!