Azure AI Document Intelligence
An Azure service that turns documents into usable data. Previously known as Azure Form Recognizer.
1,535 questions
why setting a field data type to date does not provide a formatted date value?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 46%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFH%3C/text%3E%3C/svg%3E)
Fedi Hachicha
26
Reputation points
Hello Community,
I am facing an issue since many days ago. Let me describe the problem. It is related to date fields such as InvoiceDate or DueDate. When I open an invoice in Azure Form Recognizer and I analyze it with the Invoice Prebuilt model, I obtain the content, value, and confidence of the field. I noticed a good feature regarding date fields: their values are in this format (YYYY/MM/DD). Check the screenshot:
However, when I create a custom model and I set the InvoiceDate field data type to date and I train the model, if I analyze the same document with this custom model, I only obtain the content without a value. Check the screenshot:
This kind of issue also appear for currency fields such that TotalAmount, but this data type does not exist for custom models.
Looking forward for your help, suggestion, and advises.
Fedi
{count} votes
-
romungi-MSFT 43,696 Reputation points Microsoft Employee2022-09-22T06:59:21.607+00:00 @Fedi Hachicha This behavior is actually as per design. The pre-built models use the value parameter in output apart from the content field, but the custom models just use the content parameter only. The ouput JSON for both the scenarios would be the following:
Prebuilt models:
"fields": { "InvoiceDate": { "type": "date", "valueDate": "2022-02-06", "content": "02/06/2022",Custom models:
"fields": { "Start Date": { "type": "date", "content": "02/06/2022",As seen from the above structure the
valueDateparameter is defined in response for prebuilt models but for custom models when you define a field for date type, only content parameter is provided as response apart from thetypeparameter of the field. -
Fedi Hachicha 26 Reputation points
2022-09-22T08:13:54.413+00:00 Hi @romungi-MSFT ,
I don't agree with you saying that the response always comes with only the content. By default, fields' data type are set to string, and the response always gives content and values. Check the screenshot:
I also tested it with integer and number data type where I also get a value different than the content.
Check this post: https://learn.microsoft.com/en-us/answers/questions/469855/azure-form-recognizer-incorrect-date-conversion.html
Even with the old API, the value can be obtained and also being formatted.
Sign in to comment