How do we filter date and time values such as ‘1/15/2019 4:08:48 PM’ from a range

[ThrottleWorks]

Hi,

How do we filter date and time values such as ‘1/15/2019 4:08:48 PM’ from a range.
I have a range, in this range we have a column for dates.

And I have stored date be filtered in a cell, let us say, cell A1.
And range to filter the dates is B1:B50.
How do I filter value from cell A1 in range B1:B50.

Can anyone please help me in this.

 

[vletm]

ThrottleWorks

Sub Do_TrottleWorks()
    With ActiveSheet
        dd = Format(.Range("A1"), "m/d/yyyy")
        .Range("$B$1:$B$50").AutoFilter Field:=1, Operator:=xlFilterValues, Criteria2:=Array(2, dd)
    End With
End Sub

 

[ThrottleWorks]

Hi @vletm sir, thanks a lot for the help.
I am checking this and will revert with details.

Have a nice day ahead.