Date search

[Chuck216]

Hi

I would like to have search criteria in a 2 queries, one that searches the
date field for January thru June of the current year and the other that
searches July thru December of the current year.

Thanks in advance for any help with this.
Chuck

 

[Beetle]

For the first case;

Where Year([YourDateField]) = Year(Date()) AND Month([YourDateField]) < 7

For the second case;

Where Year([YourDateField]) = Year(Date()) AND Month([YourDateField]) > 6

Replace [YourDateField] with the actual name of the field that stores your
date value.

 

[John W. Vinson]

Hi

I would like to have search criteria in a 2 queries, one that searches the
date field for January thru June of the current year and the other that
searches July thru December of the current year.

Thanks in advance for any help with this.
Chuck

As an alternative to Beetle's suggestion (which should work fine):

First half:

= DateSerial(Year(Date()), 1, 1) AND < DateSerial(Year(Date()), 7, 1)

Second half:

 

[Chuck216]

Thanks