I have a date value .now.ToLocalTime.ToString(“dd/MM/yy HH:mm:ss”) and this works fine when I print this value to out .txt file for logging purposes.
When I write this to excel however I am using split to get just the date value:
split(now.ToLocalTime.ToString(“dd/MM/yy, HH:mm:ss”),", ")
I’ve tried adding:
split(now.ToLocalTime.ToString(“dd/MM/yy, HH:mm:ss”, System.Globalization.CultureInfo.InvariantCulture),", ")
UiPath is inputting the date as mm/dd/yy into excel which is the incorrect format.
Region on PC & Excel is set to Australia
Changing formatting in excel does nothing.
Date logged in .txt is 03/08/18 = Correct
Date logged in excel: 08/03/18 = Incorrect, changing format does nothing as this is the 8th of the 3rd is a valid date in March.
I am at a loss here. Any assistance is appreciated.