Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
applying date filter in MSQuery
Hi! Can someone help me apply a criteria to an MSQuery? I want to select
same dd/mm records but for any year and can't figure out which operator to use and what to type in. Tried, for example, like and equals 13/10/????, then tried begins with, but can't use that with a date. Look forward to hearing from somene; thanks in anticipation. Kas |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
applying date filter in MSQuery
I am not familiar with MSQuery so don't know if this will help but there are
a number of places where dates cannot be handled in dd/mm/yyyy format. Has to be in mm/dd/yyyy format even though the regional date format is dd/mm/yyyy. An example of this is recording VBA code to set Excel Autofilter. The recorded code has it in dd/mm/yyyy format but the code will not run and re-set the filter and has to be edited to change it to mm/dd/yyyy format. However, having said that, I have found if the literal month is used then it works. ie dd mmm yyyy. -- Regards, OssieMac "kas" wrote: Hi! Can someone help me apply a criteria to an MSQuery? I want to select same dd/mm records but for any year and can't figure out which operator to use and what to type in. Tried, for example, like and equals 13/10/????, then tried begins with, but can't use that with a date. Look forward to hearing from somene; thanks in anticipation. Kas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Applying function after filter is applied | Excel Worksheet Functions | |||
Filter latest date from multiple date entries | Excel Worksheet Functions | |||
Dupliate names with different date Filter for newest date | Excel Discussion (Misc queries) | |||
Applying auto-filter with large number of rows | Excel Discussion (Misc queries) | |||
Filter two columns with criterion applying to one or the other? | Excel Discussion (Misc queries) |