Date format is not picked up correctly while filtering

's Computer Specifications

In Excel Macros I have taken date format as DD-MMM-YY and assigned to a
variable and same picked up variable for filtering it is not possible to
filter?? Can anybody help me out ..... Please.........

's Computer Specifications

Try this instead

Dim sDate As String

sDate = Format(Date,"dd-mmm-yy")
Selection.AutoFilter Field:=1, Criteria1:="<=" & sDate

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Vijay Kotian" <(E-Mail Removed)> wrote in message
news:1EC442D7-07A7-4574-91DF-(E-Mail Removed)...
> In Excel Macros I have taken date format as DD-MMM-YY and assigned to a
> variable and same picked up variable for filtering it is not possible to
> filter?? Can anybody help me out ..... Please.........

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel with Concatenate does not format date correctly	Tony O	Microsoft Excel Discussion	1	1st Sep 2011 09:07 PM
Cannot get date to format correctly	jknapp1005	Microsoft Excel Misc	1	28th May 2010 05:40 PM
Date format in Excel 2007 mm/dd/yy not appearing correctly	RickGCR	Microsoft Excel Worksheet Functions	2	6th Jan 2009 01:07 AM
Date filtering with spanish date format	=?Utf-8?B?SnVhbg==?=	Microsoft Access Form Coding	2	25th Apr 2007 06:40 PM
date format not working correctly	Dennis Roman	Microsoft Excel Misc	4	29th Apr 2004 02:50 PM