Hello @Emily Harper
You are correct, root cause of this issue that currently invoice supports only En-US invoices and typical US date formats. Provided invoice is from UK and it causes normalization to fail. We are working on invoice language/locale expansion but there are not exact ETA for en-Gb support.
If a lot of invoice has same date format, as a workaround you can try to do custom normalization during post processing.
It depends how many different date/price formats present in customer invoices. If it a single format, it should be pretty easy to do in any programming language, i.e. example above can be solved by removal "th" and parsing regular DateTime.Parse, see code below. But if there are a lot of different unsupported format, it will be much more complex.
var s = "6th June 2021";
s = s.Replace("nd","").Replace("th","").Replace("rd","").Replace("st","");
Console.WriteLine(DateTime.Parse(s).ToLongDateString());
https://dotnetfiddle.net/l6gMvf
Hope this will help. Please let us know if any further queries.
------------------------------
- Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
- Want a reminder to come back and check responses? Here is how to subscribe to a notification
- If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators