Hello Everyone,
I am using ABBYY Vantage to process different invoices. Therefore, I want to unify the output value for the field "invoice date". The invoice date comes in different formats, depending on the supplier.
Examples:
dd-mm-yyyy (all in numbers -> e.g. 25-03-2024)
dd Month(abbreviation) yyyy (month abbreviated with the first 3 letters -> e.g. 25 Mar 2024)
dd Month yyyy (--> e.g. 25 March 2024)
dd.mm.yyyy (-> e.g. 25.03.2024)
Now I want to unify the format, so that the output always uses the format dd/mm/yyyy
How can I achieve that?
I tired to create an advanced rule with JavaScript, however it didnt work.
Do you have any idea what i did wrong or is there another way to unify the date in abbyy vantage?
コメント
1件のコメント
Hello Miriam,
Extracted dates can contain date and time in any format. The following characters can be used as separators: the dot (.), the space ( ), the hyphen (-), the backslash (\), and the forward slash (/).
When normalizing dates, Vantage converts extracted dates into a standardized ISO 8601 format:
•YYYY-MM-DD for dates: year followed by month followed by day.
•HH:MM:SS for time: hours followed by minutes followed by seconds.
In this case, if you wish to get in the output file a date in the format DD/MM/YYYY, you may use the text field instead of the date. This is the only way how to do it.
サインインしてコメントを残してください。