*I don’t like to add to an already full list of questions but i can’t find the answer in the Forum or anywhere on the internet. Not even the Russion UiPath docs *
In the Taxonomy Manager the Date Type has a default “DefineFieldFormat” which seems to be Year, Month, Day. The Extracted Data therefore defines it as such but this causes the Year and Day are swapped.
Ie: 19/05/20 should be 19th May 2020 but is instead 20th May 2019 :-/
How does one enter the preferred format in the Edit Field section: Expected format (optional) )
I’ve tried: (Day,Month,Year) … (Day/Month/Year) … Day,Month,Year … Day/Month/Year.
“FieldName”: “Date Issued”,
“DeriveFieldsFormat”: “(Day, Month, Year)”,
The alternative i guess is to export the data to Excel and then use string date parsing and ignore the layout in the Validation Station. The same applies to the Address and Name Type.