I have situation where I download data from SAP and in the data table I do a filter on the date for a certain condition there is no output in the new data table.
The Grn Date is in TEXT format when it is downloaded. I changed it to DATE format or to General and tried it did not work for me.
I am attaching a sample file.
Test_Date.xlsx (9.8 KB)
Appreciate your valuable tips/thoughts on the same.