Filter a Date

[Anthony G.]

Hello to All:

If the souce data contains a date field and the format is 12/6/2004 - using a select query - how would I filter out all information post 11/30/2004? Basically, I'm looking to obtain year-to-date November 30, 2004 data.

Thanks,

Anthony

 

[HomerJ]

<#12/1/2004#
as your criteria in the date field of your query should do the trick.

If your source data starts prior to 1/1/2004 then you would want to use...

Between #1/1/2004# and #11/30/2004#

 

[Anthony G.]

Perfect....Thanks!!!!