Filter data table problem

[Olivera_Kalinic (Olivera Kalinić)]

Hi, I want to filter input table in the way below

, but I’m getting this error

“Filter Data Table: Conversion from string “Column104” to type ‘Date’ is not valid.”

How can I format input “Column104”?

[RajKumar_DC (RajKumar Durai)]

Hi @Olivera_Kalinic,

The error message you’re seeing indicates that UiPath is attempting to convert the value in the “Column104” column to a date, but it is not able to do so because the value is not in a valid date format.

To resolve this issue, you will need to check the data in the “Column104” column and ensure that it is in a valid date format. You may also want to check the format of the column in the input DataTable to ensure that it is set correctly.

or else

share your requirement will try deferent way

Thanks,

[Olivera_Kalinic (Olivera Kalinić)]

That “Column104” is on the CZ place and it is in the right format…
Do you need some other suggestion?

[ppr (Peter Preuss)]

it looks like you are trying to extract 3 cols from a datatable. 2 cols are fetched native and the third one you want to fetch within a conversion.

The activity is expecting the columnname or column index, but is not supporting this type extraction configuration

taken form docu

@Olivera_Kalinic

, but I’m getting this error

“Filter Data Table: Conversion from string “Column104” to type ‘Date’ is not valid.”

the statement will fail for several reasons:

• pass the compiler level as it will return a string which is interpreted as the column name.
• fails on run as the value “Column104” is taken as the string converted into a datetime which is not valid as “Column104” is not representing a date

We dont know more details about your modelling and if it is involved within nested loop … or others

Instead of you can:

• use a helper column and assign the reformated value in adavance, then extract Col115,98 and the helper column
• using a LINQ statement along with some preperations

[RajKumar_DC (RajKumar Durai)]

Hi @Olivera_Kalinic ,

Ensure that the column values type is Date or Dot.

Thanks,

[Olivera_Kalinic (Olivera Kalinić)]

Column is type Date “dd.MM.yyyy”

[RajKumar_DC (RajKumar Durai)]

Hi @Olivera_Kalinic ,

Need to confirm like below screenshot.

Thanks,

[Anil_G (Anil Gorthi)]

@Olivera_Kalinic

So let me explain what you are doing then may be that would route you to what you want to acheive…

So what you are doing is that you are trying to convert column104 to a dateformat…when i say column104 it is not the column value but its literally the name column104… that is the reason bot is failing because a string or name cannot be converted to date…

Do you want each date in the column to be converted to any specific format?

If so then after filtering you cna to loop through each row and update the data …

For each row in datatable

Inside it assign with currentrow("datecolumn") = cdate(currentrow("datecolumn").ToString).ToString("MM/dd/yyyy")

Assuming the column type is string

Cheers

Cheers

[Olivera_Kalinic (Olivera Kalinić)]

Column type is set to Date

but when I print it to output, I’m getting these values

[Anil_G (Anil Gorthi)]

@Olivera_Kalinic

In the resd rnage properties please change displayvalue option…from rawvalue

In the backend excel Stores them as these numbers

Cheers

[Olivera_Kalinic (Olivera Kalinić)]

But I can’t see display value in the properties of Read range activity

[ppr (Peter Preuss)]

@Olivera_Kalinic

but when I print it to output, I’m getting these values

Ship Date format

We would recommend to handle / harmonize the date value before adding the QueueItem / populating the Specific Content In the case for handling this numerical value you can do: [grafik] So for robusten it up you can think about cascading the datevalues cell formating value format type check handling dateTime Strings handling OADate numbers

Parse date into a single format

we can make use of the following building blocks: [grafik] Parsing many formats in one go ensure the following: [import_systemglobalization] arrFormats = {“dd/MMM/yyyy”, “dd-MM-yyyy”, … your other formats} DateTime.ParseExact(YourString, arrFormats, cultureinfo.InvariantCulture, DateTimeStyles.None) feel free to adapt the culture info Finally we can check which case we do have to handle e.g. with regex \d+ → OADate NA → not parseable … Bringing all together we can parse the date and…

[Anil_G (Anil Gorthi)]

@Olivera_Kalinic

I guess you are using extended activities which is not official…

Try using the read emage frol
The excel activities under app integration and you will see an option to preserve format

Cheers

[Olivera_Kalinic (Olivera Kalinić)]

@Anil_G
What is the name of that activity?
Unfortunately I couldn’ find it…

Thanks in advance!

[Anil_G (Anil Gorthi)]

@Olivera_Kalinic

Please check this

Apart from this first check in Manage packages if you have downlaoded UiPath.Excel.Activities package

cheers

[Olivera_Kalinic (Olivera Kalinić)]

@Anil_G

currentrow(“datecolumn”)

@Anil_G

I tryed with updating column like you described

, but getting this

Assign:Assign: Conversion from string “44480” to type ‘Date’ is not valid.

It seems that Read range activity converted all values from Column4 from format “dd.MM.yyyy” (Excel file) to some number (example: “44480”).

Do you know what can cause this situation?

[Anil_G (Anil Gorthi)]

@Anil_G

In the backend excel Stores them as these numbers

@Olivera_Kalinic

Above is the reason…

Did you try this

@Anil_G

Please check this

Apart from this first check in Manage packages if you have downlaoded UiPath.Excel.Activities package

Or

Doing cdate wont work here you can try like this

DateTime.FromOADate(currentrow("column").ToString).ToString("MM.dd.yyyy")

Cheers