| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date format is not picked up correctly while filtering
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......... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date format is not picked up correctly while filtering
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" wrote in message ... 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......... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot get date to format correctly | Excel Discussion (Misc queries) | |||
| how do I sort by picked-up date in Excel | Excel Worksheet Functions | |||
| Date format in Excel 2007 mm/dd/yy not appearing correctly | Excel Worksheet Functions | |||
| why won't my cells format correctly? | Excel Worksheet Functions | |||
| MY SPREADSHEET IS NOT FILTERING CORRECTLY | Excel Discussion (Misc queries) | |||
Linear Mode
