web
You’re offline. This is a read only version of the page.
close
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

I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    133 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
    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

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,092

#2
YUN ZHU Profile Picture

YUN ZHU 663 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 515

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans