My bank documents have two dates with different format, one for the date of operation, one for the effective account change. Plus the first one misses the year. Here is a snapshot:
So I need to be able to declare two different date formats and get the year when missing from the other date field, with some heuristic to get the appropriate year where the date are the closest (e.g 30/12 and 02/01/2023: the first one is 30/12/2022 and not 30/12/2023).
My bank documents have two dates with different format, one for the date of operation, one for the effective account change. Plus the first one misses the year. Here is a snapshot:
So I need to be able to declare two different date formats and get the year when missing from the other date field, with some heuristic to get the appropriate year where the date are the closest (e.g 30/12 and 02/01/2023: the first one is 30/12/2022 and not 30/12/2023).