VBA Doesn't Understand My Date Format (Autofilter)

**clattenburg cake** · 06-17-2013, 12:26 PM

I am trying to get VBA to filter and delete dates a week later than today, however everytime I put it through the filter it just unticks every date. I can't seem to figure out what is wrong with my code- do I have to format something differently?

Please Login or Register  to view this content.

**Norie** · 06-17-2013, 12:27 PM

You aren't actually including your date in the filter.

Try this.

Please Login or Register  to view this content.

**clattenburg cake** · 06-17-2013, 01:07 PM

Originally Posted by Norie

You aren't actually including your date in the filter.

Try this.

Please Login or Register  to view this content.

The same issue occurs, everything is unticked and all data is hidden.

If I actually use

Please Login or Register  to view this content.

VBA seems to understand that format and returns the correct data. Which is why I assumed it could be a formatting problem?

**Norie** · 06-17-2013, 01:10 PM

VBA can be weird about dates, especially in filters.

What I usually do is to add a formula in a column next to the data that indicates if the row satisfies the criteria and then filter on that column.

**clattenburg cake** · 06-17-2013, 01:41 PM

Originally Posted by Norie

VBA can be weird about dates, especially in filters.

What I usually do is to add a formula in a column next to the data that indicates if the row satisfies the criteria and then filter on that column.

Good idea, will do that.