select list of birthdays (regardless of the year they are in)

Sorry Tim,
I read your the title to your question too quickly, and didn't note the part about "regardless of the year".  What you could do is pull the month and day out of the date for the birthday, and create a WHERE clause in which you specify that you select all birthdays with matching months and days within your given range.

Ex.
WHERE MONTH([birthday]) > 7 AND MONTH([Birthday]) < 10

You could do the same for the day as well.  Hope this helps.

Mike

Tim,
Use the built in Format function.  Create a new column in design view that has the following as the field:

 Format([BIRTHDAY],"mm dd")

and then enter the following into the criteria line:

 Between Format([STARTDATE],"mm dd") And
 Format([ENDDATE],"mm dd")

This should be all you need to do.

Jo Shmo

I would do something like Jo Shmo but I would actually use the built in date funcions a little different.

I would make a column of ther birthday this year.

bdnow:format(format([bday],"mm/dd") + format(now(),"yyyy"),"mm/dd/yy") then just use a between statment in the where clause

where bdnow between [Start_date] and [End_date]

HTH
Jag5x5

does my way not work?

Jag,
Your example yields funky looking non-dates.  I'm curious about what you were trying to do though.  What is it you were trying to accomplish by adding the birth month and day to the current year, and then formatting that as "mm/dd/yy"?

I mean no disrespect, I'm just curious.
-Jo

confusion... i wasn't doing any FORMATing...
Doesn't my select statement do it all in one?

jagoodie Your way would work if you were only trying to do a single month otherwise you need to break it into two columns.

select * from People where month(bday) between month([Start_date]) and month([End_date]) and day(bday) between day([Start_date]) and day([end_date])

My way should add the current year to the month and day from the Birthday.

I Ran it and it worked fine here is the SQL From my Query
SELECT Bday.*
FROM Bday
WHERE (((Format(Format([Bday],"mm/dd")+Format(Now(),"/yyyy"),"Short Date")) Between #5/1/2002# And #6/1/2002#));


Jag5x5

I gues I forgot A slash in my original code it was

--bdnow:format(format([bday],"mm/dd") + format(now(),"yyyy"),"mm/dd/yy") then just use a between statment in the where clause

where bdnow between [Start_date] and [End_date]


And should have been

bdnow:format(format([bday],"mm/dd/") + format(now(),"yyyy"),"mm/dd/yy") then just use a between statment in the where clause

where bdnow between [Start_date] and [End_date]


Sorry
Jag5x5

timdesomere,
No comment has been added lately (150 days), so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question.

RECOMMENDATION: Accept jagoodie's Comment as Answer

Please leave any comments here within 7 days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Thanks,

nexusnation
EE Cleanup Volunteer