Did you look at the DATEPART function? You should be able to do the following:
SELECT *
FROM MyTable
WHERE DATEPART("m", MyTable.DateField) = 5; Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...
I have been unsuccessfully trying all kinds of variations of the DatePart function to condense a short date to just the month AND a two digit year.
How can I make all entries from 5/01/02 through 5/31/02 show as 5/02?
I found this non-DatePart expression works but it gives me a 4 digit year and I'd prefer a 2 digit year: Expr1: Month([Date]) & "/" & Year([Date])
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.