I have a requirement to check whether row values are of format (YYYY-MM-DD HH:MM)
In my excel there is a column called “Invoice date” and one of its row value is “2021-03-18 22:00” (YYYY-MM-DD HH:MM) but when i read that cell from uipath i was getting the value as “3/18/2021 10:00:00 PM” .
I got one partial solution when i check the Preserve Format property in read range (2021-00-18 22:00) bot was not able to get “MM” value.
we Need help on this .
Thanks in advance.