Date criteria in autofilter

[bramcode]

Hi buds,
this problem has been driving me crazy, i have a range of data in excel sheets, and one of the column containes DATE located in field 1, and i 'm writing a macro to display the results based on date criteria. I've been very careful in this DATE things, and i use calendar control to input the date value for the DATE field, so it's safe to say that the date values are correct. Now i use the srcripts below to display data with date criteria, but i keep getting blank page instead of the results that i wanted.
Sub cmd_inventory ()
txtDate.text = Calendar1.value
With Sheets("inventory")
.AutoFilterMode = False
.Range("inventory").AutoFilter
.Range("inventory").AutoFilter field:=1, Criteria1:= txtDate.text



End With

End Sub

Thank you

[venkat1926]

use criteria as
cdate(<actual date>)


I am giving you a trivial example
suppose data is like form A1

hdng1 hdng2
1/1/2012 1
1/2/2012 2
1/3/2012 3
1/5/2012 4
1/5/2012 5
1/6/2012 6
1/2/2012 7
1/8/2012 8
1/9/2012 9
1/2/2012 10

now try this macro

Please Login or Register  to view this content.

Please Login or Register  to view this content.

use this idea to solve your problem