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

Announcements

Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Data exchange definiti...
Small and medium business | Business Central, N...
Answered

Data exchange definition - problem with date

(0) ShareShare
ReportReport
Posted on by SYLV1G 55

Dear all,

I try to import a file to a payment reconciliation journal so I created a data exchange definition and was able to import all fields except dates. I made several settings tries without success

Has anybody go an idea to solve this issue?

Thanks in advance

pastedimage1639065988228v1.png pastedimage1639066079175v3.png

pastedimage1639066027245v2.pngpastedimage1639066130282v4.png

I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    JAngle 159 on at

    Shouldn’t YYYY be yyyy? The format mentions “.”, assume you have tried breaking up in that way too? Failing progress with standard a custom transformation rule is a wise plan. This is helpful: https://youtu.be/L2qt0GKmiGk

  • Verified answer
    SYLV1G Profile Picture
    SYLV1G 55 on at

    It worked with the settings bellow

    Thanks

    pastedimage1639081519733v1.png

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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 686 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 447 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 328 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans