ACCESS FEED: RE: [MS_AccessPros] How to find "This Month"

Jumat, 08 Februari 2013

RE: [MS_AccessPros] How to find "This Month"

Hi Robin

This should do the trick:

... WHERE Format([MonthDate],'yymm') = Format(Date(),'yymm')

or this:

... WHERE (Year([MonthDate])=Year(Date())
AND Month([MonthDate])=Month(Date()))

Best wishes,
Graham

> From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Robin Chapple
> Sent: Saturday, 9 February 2013 17:14
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] How to find "This Month"
>
> I have a table with records date stamped with a 'Date' field - "MonthDate"
>
> I need to add criteria to a query that will supply "This Month" only.
> All my attempts have failed.
>
> How do I select records for "This Month"?
>
> Many thanks,
>
> Robin Chapple