Hello everyone! I have a Table in excel where one column contains information about dates.
When I log the mentioned data to UiPath Studio it shows as “mm/dd/yyyy” but it needs to be filled as “dd/mm/yyyy”
I could transform the variable´s type as System.DateTime but when I make the assign: FormatDate = originalDate.ToString("dd/MM/“yyyy”) I get the following error:
CaptureData.xaml: BC30512: Option Strict On disallows implicit conversions from ‘String’ to ‘Integer’. The selected value is incompatible with the property type.
This means we will not be able to convert or assign a string type value to a integer variable
So here ur value is string and
Variable is integer type
As u r getting date value in string format as a output, the variable that is holding also needs ro be same string format
Change the variable type of FormatDate to String
To Convert Date Value from String Format to DateType Format you can either use an expression or Modify Date Activity to proceed futher on this one.
Example: “02/09/2023” to 02/09/2023 (String to Date Format)
Also, You can desired the format of date you need “dd/MM/yyyy” or “MM/dd/yyyy” or Any format which you needed. I hope this will be helpful