Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Data exchange definition - problem with date

(0) ShareShare
ReportReport
Posted on by 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

  • Verified answer
    SYLV1G Profile Picture
    55 on at
    RE: Data exchange definition - problem with date

    It worked with the settings bellow

    Thanks

    pastedimage1639081519733v1.png

  • Suggested answer
    JAngle Profile Picture
    95 on at
    RE: Data exchange definition - problem with date

    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

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

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

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

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,655

#2
Mansi Soni Profile Picture

Mansi Soni 1,574

#3
YUN ZHU Profile Picture

YUN ZHU 1,453 Super User 2025 Season 1

Featured topics

Product updates

Dynamics 365 release plans