Autofilter problem with date format

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

How are your dates stored in the spreadsheet? How are they handled by your variables FECHA and ANTERIOR? My first guess is that in one place the dates are real numbers/dates and in the other place they are text strings that only look like dates. I would be sure the dates are stored as dates (double data type as VBA would see them) in the spreadsheet, then make sure the FECHA and ANTERIOR are receiving the dates as numbers/doubles/longs so that the data type will be consistent between VBA and Excel.

Filtering Dates is most of the times tricky. Make sure the date criteria and the target date column have the same date format and it should work then without an issue.

Macro1:

Please Login or Register  to view this content.

Macro2:

Please Login or Register  to view this content.