I created a custom document on DocumentUnderstanding (Modern). The date is always in the same German format, and it always extracts the correct value. Format: dd.MM.yyyy
Last month, the extracted value as a string representation was this: 05/25/2025, so it’s in this format: MM/dd/yyyy, which is no problem at all for me.
I could just parse it exactly like so: Date.ParseExact(mydate, "MM/dd/yyyy") and later in my robot i can then put the date in into an input field for example like this: mydate.toString("dd.MM.yyyy").
The problem is that this month, the date comes back like this: 04/06/2025, which with my formula is suddenly the 6th of April and not how it should be: the 4th of June.
So why is DocumentUnderstanding extracting the correct text every time but interpreting the date differently? How can I fix this?
TL;DR
Last month Document Understanding interpreted date as: MM/dd/yyyy
It is running in the cloud. UiPath Extracts the date and gives it my DocumentUnderstanding Robot.
This robot adds a queue entry with that variable: DataTableExtracted(0).Rows(0).Item("vorfallsDatum").ToString
DataTableExtracted is this: in_ExtractionResults.DocumentMetadata.ResultsAsDataTables
It’s the default Document Understanding Studio Template for Modern DU.