VBA : Filter data using today's date

[Pradboule]

Hello,

I would like to fileter data by a date column and 2 limit parameters.
Basically, I want to select the line for which the date in column G is between today - nb1 (nb1 number of days) and today - nb2 (nb2 number of days).

So I use the following code to filter it :

Please Login or Register  to view this content.

The problem is, no line is selected.
Then I check manually the filter, I can see the two limit dates and when I apply the filter again (without changing dates), the line appear.
I just do not understand why it does not work with the macro in the first place.

Would any of you have a solution?

Thanks in advance!
Louis

[nathansav]

Can you send the book?

[Pradboule]

Here it is,

Book2.xlsm
Thanks,
Louis