Date Query

  • Thread starter Thread starter DSmith
  • Start date Start date
D

DSmith

I know in the criteria of a birth field I can use 7/??/?? to find everyone
born in July. Is there something I can do to find everyone born in July but
only if it was an even year? Any help would be appreciated. Thanks.
 
Is your birth field a text field or a date? I've never used wildcards in
querying a date field. Does that really work?

You could do something like:

Format([DateField], "mm/dd/yy") LIKE "*[02468]"
--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.
 
It's a date and wild cards work fine. I just need to find everyone born in
an even year in July. I'll try your suggestion.

Dale Fye said:
Is your birth field a text field or a date? I've never used wildcards in
querying a date field. Does that really work?

You could do something like:

Format([DateField], "mm/dd/yy") LIKE "*[02468]"
--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.



DSmith said:
I know in the criteria of a birth field I can use 7/??/?? to find
everyone
born in July. Is there something I can do to find everyone born in July
but
only if it was an even year? Any help would be appreciated. Thanks.
Click to expand...
Click to expand...
 
Worked great I just put the 7/??/?? and Format([DateField], "mm/dd/yy") LIKE
"*[02468]"
in the criteria of the birthdate field and it returned everyone with a
birthday in July born in an even year.

Thanks!

Dale Fye said:
Is your birth field a text field or a date? I've never used wildcards in
querying a date field. Does that really work?

You could do something like:

Format([DateField], "mm/dd/yy") LIKE "*[02468]"
--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.



DSmith said:
I know in the criteria of a birth field I can use 7/??/?? to find
everyone
born in July. Is there something I can do to find everyone born in July
but
only if it was an even year? Any help would be appreciated. Thanks.
Click to expand...
Click to expand...
 
Back
Top