applying date filter in MSQuery

K

kas

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
 
O

OssieMac

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top