How to autofilter by exact date?

Debaser · #5 06-18-2018, 03:46 AM

It is generally safer with dates and filters to convert to numeric values - for example:

Code:

.AutoFilter Field:=12, Criteria1:=">=" & CDbl(STARTDATE), operator:=xlAnd, criteria2:="<=" & CDbl(STARTDATE)

This assumes that STARTDATE is a Date type variable. If not, you can convert that using CDate like this:

Code:

.AutoFilter Field:=12, Criteria1:=">=" & CDbl(CDate(STARTDATE)), operator:=xlAnd, criteria2:="<=" & CDbl(CDate(STARTDATE))

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to write if condition for AutoFilter to check ..?	LearnerExcel	Excel Programming	1	05-05-2018 08:53 AM
Autofilter on two Date Columns	OTPM	Excel Programming	3	04-29-2014 12:56 AM
How to count even exact date 90 days	redza	Excel	1	09-17-2013 03:36 AM
Sum on AutoFilter	Grasshopper	Excel	3	02-14-2013 01:41 AM
AutoFilter Criteria3	coxjamd	Excel Programming	2	01-17-2013 02:24 PM