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.