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
Your query is quite confusing, be more specific and better to share the dummy data.
Can you share the excel 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
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!
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 
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!
Change DataType of your TarihDt variable to DateTime from Variables Panel.