web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Dates mismatched between CE and FO

(0) ShareShare
ReportReport
Posted on by 405
We are facing a weird issue with the dates in dual-write integration. We have custom date fields created on the sales line table in FO and mapped it with CE custom fields. It's simple DW mapping without any business logic around it.
We see a date mismatch for CE to FO flow. We observed this behavior mainly happening with the users in the Australian timezone, but I can not deny this is happening with the users in different time zones.
The timezone for the dualWrite user is set as GMT. 
I appreciate any help you can provide. 
 
CE Start date CE end dateFO StartFO End
6/26/20236/28/20232023-06-25 00:00:002023-06-27 00:00:00
8/7/20238/9/20232023-08-06 00:00:002023-08-08 00:00:00
8/7/20238/9/20232023-08-06 00:00:002023-08-08 00:00:00
8/21/20238/23/20232023-08-20 00:00:002023-08-22 00:00:00
12/4/202312/4/20232023-12-03 00:00:002023-12-03 00:00:00
I have the same question (0)
  • Martin Dráb Profile Picture
    236,888 Most Valuable Professional on at
    Dates mismatched between CE and FO
    When talking about the date in F&O, are they date or utcDateTime fields? If the latter, are you showing us at values in database (UTC) or what a user see in GUI (which depends on his/her timezone)?
  • Expertopinionsa12 Profile Picture
    51 on at
    Dates mismatched between CE and FO

    Hey there!

     

    So, you've got a little problem with the dates in our CE to FO flow. It's not syncing up properly, especially for your users in the Australian timezone. But hey, your users in other timezones might be facing it too.

     

    To fix this date issue, here's what we need to do:

     

    First things first, let's double-check how we handle timezones in our mapping process. We want to make sure we've got the right timezones for CE and FO flows without any mix-ups or conversion errors.

     

    Next, we gotta settle on a single date format for both CE and FO. It'll make things less confusing and reduce the chance of making mistakes during conversion. Choose a format that works for both systems and keeps the mapping accurate.

     

    If our CE and FO flows are in different timezones, we need to do some proper timezone conversion during data transfer. We can rely on a reliable method or library to handle this conversion accurately, so we don't end up with any more date mix-ups.

     

    Lastly, let's test the date mapping with users in different timezones. It's not just our Australian friends facing this issue, so we want to make sure our mapping works perfectly for everyone, no matter where they are. This may sound overwhelming but trust me it’s not coz this is what we do at Triotech Systems or any other client’s projects. 

     

    By following these steps, we'll fix the date mismatch problem and ensure our mapping process runs smoothly without any complicated business logic.

     

    Hang in there, you got this!

  • Martin Dráb Profile Picture
    236,888 Most Valuable Professional on at
    Dates mismatched between CE and FO
    This is a lot of text without any actual information. It looks to me like text generated by AI just to promote the company mentioned in the text.

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 76 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 55 Most Valuable Professional

#3
Anthony Blake Profile Picture

Anthony Blake 43 Super User 2025 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans