How do I filter between two dates in YYYYMM format?

[Knockoutpie]

I'm really at a loss here as I cannot start my project without first completing this step..

In column 'A' I have dates in YYYYMM format and i'm trying to filter between ranges from YYYY-1/MM to YYYY/MM-1 (where YYYY/MM = current year/current month)

Between current year minus 1 year and then current year and month minus 1 month.

Any help would be greatly appreciated.

[TABLE="width: 61"]
<tbody>[TR]
[TD]YYYYMM[/TD]
[/TR]
[TR]
[TD]201805[/TD]
[/TR]
[TR]
[TD]201805[/TD]
[/TR]
[TR]
[TD]201706[/TD]
[/TR]
[TR]
[TD]201805[/TD]
[/TR]
[TR]
[TD]201902[/TD]
[/TR]
[TR]
[TD]201805[/TD]
[/TR]
[TR]
[TD]201805[/TD]
[/TR]
[TR]
[TD]201805[/TD]
[/TR]
[TR]
[TD]201805[/TD]
[/TR]
[TR]
[TD]201805[/TD]
[/TR]
[TR]
[TD]201805[/TD]
[/TR]
[TR]
[TD]201805[/TD]
[/TR]
[TR]
[TD]201805[/TD]
[/TR]
[TR]
[TD]201805[/TD]
[/TR]
[TR]
[TD]201805[/TD]
[/TR]
[TR]
[TD]201902[/TD]
[/TR]
[TR]
[TD]201805[/TD]
[/TR]
[TR]
[TD]201805[/TD]
[/TR]
[TR]
[TD]201805[/TD]
[/TR]
[TR]
[TD]201705[/TD]
[/TR]
[TR]
[TD]201805[/TD]
[/TR]
[TR]
[TD]201805[/TD]
[/TR]
[TR]
[TD]201804[/TD]
[/TR]
</tbody>[/TABLE]

 

[dmt32]

Hi,
if want VBA solution following untested but see if does what you want

Sub FilterDates()


        Dim StartDate As Long, EndDate As Long
    
        StartDate = DateSerial(Year(Date) - 1, 1, 1)
'0 - represents the last day of the previous month
        EndDate = DateSerial(Year(Date), Month(Date), 0)
        
'apply filter
        ThisWorkbook.Worksheets("Sheet1").UsedRange.AutoFilter Field:=1, _
                                                Criteria1:=">=" & StartDate, _
                                                Operator:=xlAnd, _
                                                Criteria2:="<=" & EndDate
End Sub

Dave