AutoFilter Not Working By Date Due To Date Format Difference DD/MM/YYYY Vs MM/DD/YYYY

[marreco]

Hi folks

i am desperate and so, i did the cross-posting

I have two combobox cmb_Dt_Inc (start date) and cmb_Dt_Fin (end date).

I need show result in ListView.

Cross-Post
Filter by Date and Show in LisView

Thanks

[Excel Fox]

Hi Marreco,

Replace the function with this

Public Sub ComboboxChange(cmbTarget As MSForms.ComboBox, iComboboxNo As Integer)

    Dim iColumnNo As Integer
    
'   Muda a cor se tiver conteúdo
    If cmbTarget.Value = vbNullString Then
          cmbTarget.BackColor = &HFFFFFF
    Else: cmbTarget.BackColor = &H80C0FF
    End If

'   seleciona a planilha fliltro e coloca o valor da combo
    iColumnNo = iComboboxNo

    If IsDate(cmbTarget.Value) Then
        Sheets("Filtro").Cells(2, iColumnNo) = CDate(cmbTarget.Value)
    Else
        Sheets("Filtro").Cells(2, iColumnNo) = cmbTarget.Value
    End If
    
    Call Pesquisa

End Sub

[marreco]

Hi.

works, but when I use another combobox (cmb_Dt_Fin) are filtering only the last action of the combox.

See my image

thank you!!

[marreco]

Hi.

any idea?

thanks

[Excel Fox]

marreco, that is because of the way you have setup your filtering criteria. The way you have defined it, you are using a single row of data as your criteria. This works as an AND operator, and it isn't working as you intend (>= / <=)