Filter Excel date does not work

[VLC]

Hello all,

i am Filtering an Excel like this:

And the filter is also correctly set in Excel:

However as you can see in the backround the Excel is empty.

When I now press ok it will be filtered correctly:

Any Ideas whats the issue?

[ashokkarale]

@VLC,

Check if your excel date column is of Date Format or not. If it’s not Date format then the filter won’t work.

Solution?
You can use Format Cells activity to format the desired column to specific date format and then use filter activity

[VLC]

Hi, yes its definitly in date format

[ashokkarale]

@VLC,

Can you try replacing this highlighted value

with this one. This will convert your comparison string date to datetime datatype

DateTime.ParseExact("01.03.2025","dd.MM.yyyy",System.Globalization.CultureInfo.InvariantCulture)

[Anil_G (Anil Gorthi)]

@VLC

if it is date cell then you need to give the date in the format it takes

that is in display it might display based on dot format..but wwhen you select a date from the icon highlighted below it would come in a specific format..that format is what is to be used in the filter

generally that would be the system date format

for example for me display is with dots but system is with dash

Hope this helps

cheers

[VLC]

Hi Anil,

thank you for your contribution.

The format is the same.

I really think I use the acitivity wrong as I can set a breakpoint in the process and just confirm the filter again UI Path has set and it works

[Anil_G (Anil Gorthi)]

@VLC

Just to check try to set filter manually

Copy the same value and use in UiPath and check

Cheers

[VLC]

Hi Anil, I just tried it. Unfortunatley it wont work

[VLC]

Hello I tried it.

It says that I cant convert date to String

[Anil_G (Anil Gorthi)]

@VLC

you dont need to use datetime. and all..just get the value from excel and paste in UiPath

cheers

[sudster]

Hi @VLC ,
Did you test using the ToOADate() function?

1. Convert the date to compare into a DateTime var, e.g. dateTarget
2. In the filter >= dateTarget.ToOADate.ToString

[VLC]

Hi Anil, I did.

What you mean was an asnwer do a diffrent comment by another person.

[sudster]

Example of my procedure:

Initial data:

Sequence:

Result: