Filtering Date Column in Excel

Help Studio
1

I am reading in an excel file into a data table and then using Filter Data Table/Filter Wizard to extract just the data I want. I am able to filter on all of the columns except for one that is of the data type Date.

I have tried doing:
If column “Registration Date” contains “2020” but that returns nothing. I am assuming it is because I am treating it like a string when it is not.

Has anybody experienced this and been able to fix it or have an idea of how to? Thanks in advance.

2

Hi @jpreziuso,

Check the workflow below i had used linq query for filtering i tried your case of registartion date too it worked fine

sample_12.zip (2.6 MB)

Check this and let me know if it works

Hope it helps you

Regards
Nived N

1 Like
3

Yes this worked. Thank you!

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.