Usage of date or time functions does not consider local settings

[Christian_Hennig]

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):

[aksh1yadav (AKSHAY YADAV)]

Hey @Christian_Hennig

@Christian_Hennig

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.

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

Unable to compare date

Are you sure about this? I’m pretty certain that for calls made within UiPath the default culture is invariant, unless you specifically provide a different one. Sample output when running on pl-PL user settings and en-US interface: UiPath: [image] C#: [image] Same will happen with Decimal.Parse etc. Unless by default you ment good practice, in which case I agree (in most cases - monitoring systems are IMHO better left at UTC or one specific timezone). Regards, Andrzej

Regards…!!
AKsh

[Christian_Hennig]

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.

[andrzej.kniola (Andrzej Knioła)]

Try this:

How to convert string to double with proper cultureinfo