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?
Comments
1 comment
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.
Please sign in to leave a comment.