Validating Dates that have been extracted from a Document

Hi
I am using Document Understanding to extract information from scanned pdfs.
My question is about the date fields.
When I extract them as string 02102020 , add “/” and
then use cdate it converts it to the 10th February instead of the 2nd of October.

Is there a universal setting in Studio where I can set all dates to be in the format ddmmyyyy and not mmddyyyy

Thanks

Thanks
Rachael

@rachael.sherry can u try this out
DateTime.ParseExact(YourDate, “MM/dd/yyyy”, System.Globalization.CultureInfo.InvariantCulture).Tostring(“dd/MM/yyyy”)

1 Like

Thanks :smile:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.