SQL

[George]

Hi

I have a database with a field «Birthdate».
I have to get a range of entries which have
their «Birthdate» f. e. between the 1st of
January and the 31. of March.

I have found the way to get one single
date

.... BIRTHDATE={d '1901-01-01'}

or a range between two dates:

.... BIRTHDATE BETWEEN {d '1901-01-01'} and {d '1901-03-31'}

This works fine.

My problem: I need the range between two
dates *without specifing an explicit year*.

Is there any way to query such a range of dates?

Thanks for any help.

PS: VBA - Word 2003

Best Regards

George

 

[Doug Robbins - Word MVP]

Apply a formatting switch to the Birthdate field so that it returns just the
month and the day of the birthdate, but probably just the month is all that
you need per your example criteria.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[George]

Dear Doug

Thanks for your help. I give it a try ...

Best Regards

George