Date field type behavior

[Tejaskumar_Darji]

Hello,

I capture the date field from an invoice by setting the field as the Date format.
On Batch Types, I leave the setting as usual so it keeps the date as the original format.

When this date field captures the date and date format is valid still it throws - date is invalid format.



Here field has the date in DD/MM/YYYY format but still I'm not getting why is this happening?

My purpose is to extract the date in its original format, be it whatever is the format on the invoice.

------------------------------
Thanks & Regards,
Tejaskumar Darji
Sr. RPA Consultant-Automation Developer
------------------------------

[Ben.Lyons1]

Hi Tejaskumar,

What are you Language and Locale settings in Batch Type and Document Type?

Thanks

------------------------------
Ben Lyons
Product Consultant - Decipher Specialist
Blue Prism
UK
------------------------------

[Tejaskumar_Darji]

Yeah sure here it is.

------------------------------
Thanks & Regards,
Tejaskumar Darji
Sr. RPA Consultant-Automation Developer
------------------------------

[Ben.Lyons1]

Thanks.

First thing's first. You only need to set one of the languages if they're the same (Primary & Secondary). And you only need to set the one in Batch Type if the Document Type is going to be the same. The idea is that the Document Type language would override the Batch Type, so the Batch Type is the default and other added where needed.

Secondly, the date you're reading is in the UK format, which directly conflicts with the US format e.g. today is UK 17/02/2022 is US 02/17/2022. If you get those the other way around they will validate as incorrect because the neither will be able to handle the 17th month.

So try adding the UK locale as your secondary in the Batch Type.

Thanks

------------------------------
Ben Lyons
Product Consultant - Decipher Specialist
Blue Prism
UK
------------------------------

[lookman]

Hi Tejaskumar.

I may be confused so please bear with me if my question does not make sense. You have the DFD set to date format and you've specified in the batch that the primary locale is the US. Consequently, the date you have is invalid because the default US format is MM/DD/YYYY.

Since you are not concerned about the format, why do you need the data format in the first place?

jack

------------------------------
Jack Look
Sr Product Consultant
Blue Prism
------------------------------

[Tejaskumar_Darji]

Okay, I get it now where I'm wrong. Thanks for correcting me Jack and Ben.

------------------------------
Thanks & Regards,
Tejaskumar Darji
Sr. RPA Consultant-Automation Developer
------------------------------