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 don't think this will work. But you can give it a try.
Thanks,
Girish S.
In another block i can see we can achieve this by change EntityName.postGetStagingData() method.
Below is the link.
Can i achieve this by changing postGetStagingData() method of entity?
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.
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
Currently i can import with MMDDYY format.
Is there any way i can import YYMMDD format by write the code?
Hi, Please try to export the data entity and check what date format is exported. Try importing using same format.
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.
Hello Rahul,
I would suggest you update the date format on the source file to MMDDYY and retry.
André Arnaud de Cal...
292,111
Super User 2025 Season 1
Martin Dráb
230,934
Most Valuable Professional
nmaenpaa
101,156