I have a birthdays and anniversaries table, and I want to be able to select
the birthdays that occur in the current week. But I don't know how to write
the SELECT statement. Can anyone help?
The birthday is stored in the table with Day and Month fields as integers.
It's easy enough in the middle of the month, but how do I select for this
week, when there is a month end boundary in the week?
The table structure I have is:
CREATE TABLE [anniversaries] (
[annivID] [int] IDENTITY (1, 1) NOT NULL ,
[Day] [int] NULL ,
[Month] [int] NULL ,
[name] [varchar] (255) NULL
)
Cheers,
Mike Kear
Windsor, NSW, Australia
AFP WebWorks
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
