VBA Define Date Variable as Filter Criteria

Hi,

try the following:

Please Login or Register  to view this content.

Thank you tehneXus, it is working with both Timestamp and Short Date. Is is is possible when a filter them based on Date filters not to modify the Input Data Sheet, as well as if I clear all the criteria and run the code to return all the data to the summary sheet?
Because, it is working fine but once I sort the data using a date I can not undo it.

Also, thank you very much for cleaning the code at the non-date filter criteria.

Hello to all,

I tested and discovered that after filtering based on date, filtering again with no date criteria it reveals again all the values. Is it possible to make when all the criteria are blank to return all the data?

Also at the short date filter, i tried it and it wasnt sorting the data, which is weird since for the date time-stamp is working fine : should I put the date with in #DD-MM-YYYY#?

Please Login or Register  to view this content.