Usage of date or time functions does not consider local settings

excel
uiautomation

#1

Scenario: Date or number functions do no use local date/time format. E.g. on a German system, the date.today function returns 1/1/2017 instead of 01.01.2017. Same for CDbl which takes “,” as thousands separator.

Steps to reproduce: Use any number or date function that produces different results base don the local settings. Tried the CDbl conversion from a string number (“31.345,12”) in UiPath and Excel. Excel uses local settings, UiPath not.

Current Behavior: Wrong separators

Expected Behavior: Separators based on system localle

Studio/Robot/Orchestrator Version: UiPath 2016.2.6274

Last stable behavior:
Last stable version:
OS Version: Windows 8.1 Enterprise
Others if Relevant: (workflow, logs, .net version, service pack, etc):


#2

Hey @Christian_Hennig

Calls made within UiPath the default culture is invariant, unless you specifically provide a different one.
CultureInfo.InvariantCulture that It is associated with the English language(‘en-US’) but not with a country or region.

There was already a thread and discussion available on the forum. you can look into this for more info

Regards…!!
AKsh


#3

Hi Aksh,

I think I’ve seen this thread and also used the invariant culture in a former project. But isn’t it a specific parameter for certain functions? How would I convert a string of 34.345,12 into double by using CDbl?
The purpose of the convert is, I have a net amount from SAP and from an associated Excel file (CSV format). The SAP amount is from an OCR operation and I want to compare the 2 amounts as an additional check. So I can only get the numbers in string format. I can replace the “,” and “.”, but I prefer to convert them.


#4

Try this: