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

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

Hi Marreco,

Replace the function with this

Code:

---

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

---

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!!

Hi.

any idea?

thanks

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 (>= / <=)