Macro/VBA - Filter selection by Date of current month and next month

[tropiqz]

Hi,

I have recorded a macro button which when pressed it currently filters the mm-mmm date in column 19 to 09-Sept or 10-Oct (current month and one month from now).

Sub Due()
'
' Due Macro
'


'
ActiveSheet.Range("$A$3:$V$190").AutoFilter Field:=19, Criteria1:="=09-Sep" _
, Operator:=xlOr, Criteria2:="=10-Oct"
End Sub

What i would like is instead of the current fixed dates, if the data could be filtered by the current month (0) and the next month (1) going by the date as if it was Today().

I cannot seem to get this work however, could someone kindly assist?

Thanks in advance!

 

[silentwolf]

Hi
https://www.mrexcel.com/forum/excel-questions/790172-vba-filter-only-current-month.html

 

[tropiqz]

Thanks for the response but this is still not working for me, it is just returning blanks and nothing on the filter.