Hi Team,
I have a requirement to check whether row values are of format (YYYY-MM-DD HH:MM)
Explanation:
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.
i just wanted to check whether the cell format is “YYYY-MM-DD HH:MM”, If we convert the value to CDate or DateTime Prase it will come in the form of system date which i don’t want.