Excel date filterr

Hello,
I want to filter a column whose format is date in Excel, but no data comes as a result of the filter.
reason
'column format date
Could the variable I want to filter be string?
I can’t share images

Hi @Yurdanur_Yusuf1

Your query is quite confusing, be more specific and better to share the dummy data.

Can you share the excel file?

I can’t file

Assing
TarihDt = DateAndTime.Today.AddDays(8).ToString(“dd/MM/yyyy”)

Filter Data Table

Date <= TarıhDt

How you want to filter(Means any condition)?

Regards,
Ajay Mishra

Just put Now.AddDays(8) in filter value

Or in your way:

Cheers!

It should be full of data but no data is coming in this way

Please provide sample input data and output data!

It only prints the column header

@Yurdanur_Yusuf1 Please provide sample input data and output data!

@Yurdanur_Yusuf1,

You should be using DateTime Datatype to filter the Date. String will not work.

Here is sample Solution:

Sample Code:
ExcelWork.xaml (8.3 KB)

Thanks,
Ashok :slight_smile:

I do everything the same way.
I can filter other columns that contain text. But when I filter the row in date format in this way, it does not bring the relevant rows. Only the column header is created.

Can you share with us what are you entering for date filteration?
Any syntax or ss of filter activity?

hi,
I cannot open the file you shared, can you share an image?

@Yurdanur_Yusuf1 Why are you putting “.ToString” atlast?

Put Only → Now.AddDays(14)

Not → Now.AddDays(14).ToString(“dd/MM/yyyy”)

Remove ".ToString(“dd/MM/yyyy”)"and try again!

Refer attached .xaml

ExcelDateSequence.xaml (8.8 KB)

If the issue is resolved then mark the answer as solution!

Cheers!

image

Change DataType of your TarihDt variable to DateTime from Variables Panel.