Finance | Project Operations, Human Resources, ...

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

(0) Share

Report

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)

All responses (8)

Answers (0)

Suggested answer

Komi Siabi 13,093 Most Valuable Professional on at

Like (0)

Report

Hello Rahul,

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

Was this reply helpful? Yes No
Rahul.p 632 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Rahul.p 632 on at

Like (0)

Report

Currently i can import with MMDDYY format.

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

Was this reply helpful? Yes No
Mohit Rampal 12,565 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Rahul.p 632 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

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

Thanks,

Girish S.

Was this reply helpful? Yes No