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
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How to change Date for...
Finance | Project Operations, Human Resources, ...
Suggested Answer

How to change Date format while import the data using data entity in D365FO

(0) ShareShare
ReportReport
Posted on by Rahul.p 632

Hi Team,

I will get Text file from third party application.

I have to upload the file using data entity.

In this file date format would be YYMMDD format example: 230602.

while I try to import file using data entity getting below error;

-The specified file is not in the same format as the source data format selected.

-Entity has incorrect data. Please correct the data and try the import again.

 

Please suggest how to solve the issue.

Regards,

Rahul

I have the same question (0)
  • Suggested answer
    Komi Siabi Profile Picture
    Komi Siabi 13,190 Most Valuable Professional on at

    Hello Rahul,

    I would suggest you update the date format on the source file to MMDDYY and retry.

  • Rahul.p Profile Picture
    Rahul.p 632 on at

    Hi Komi Siabi.

    Thanks for your reply.

    I have check with MMDDYY format also.

    But getting below error.

    -Entity has incorrect data. Please correct the data and try the import again.

  • Suggested answer
    Mohit Rampal Profile Picture
    Mohit Rampal 12,565 Moderator on at

    Hi, Please try to export the data entity and check what date format is exported. Try importing using same format.

  • Rahul.p Profile Picture
    Rahul.p 632 on at

    Currently i can import with MMDDYY format.

    Is there any way i can import YYMMDD format by write the code?

  • Mohit Rampal Profile Picture
    Mohit Rampal 12,565 Moderator on at

    Date format is controlled in User Options form and is applied on all datetime fields. I don't think you can change it via code for one field.

    community.dynamics.com/.../how-can-i-change-format-all-datetime-to-dd-mm-yy

  • GirishS Profile Picture
    GirishS 27,829 Moderator on at

    Hi Rahul,

    You can specify the date format for the EDT.

    Note: But the filters for the date control will not work as it will depend upon the "Date, time, number format" under the user settings.

    Thanks,

    Girish S.

  • Rahul.p Profile Picture
    Rahul.p 632 on at

    In another block i can see we can achieve this by change EntityName.postGetStagingData() method.

    Below is the link.

    https://community.dynamics.com/ax/f/microsoft-dynamics-ax-forum/204376/data-entity-staging-table-changes-prior-to-insert?pifragment-96834=1

    Can i achieve this by changing postGetStagingData() method of entity?

  • GirishS Profile Picture
    GirishS 27,829 Moderator on at

    I don't think this will work. But you can give it a try.

    Thanks,

    Girish S.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the January Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 673 Super User 2026 Season 1

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 280 Super User 2026 Season 1

#3
Martin Dráb Profile Picture

Martin Dráb 213 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans