Hmm, I always use this WHERE sp_start_month between #month(now())# and #month(now())# AND sp_start_day <= #day(now())#
On 11/9/06, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> wrote: > > And Days & Month should be TINYINT :-) > > > > > > > > > > > > "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, > Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, > Registered in England, Number 678540. It contains information which is > confidential and may also be privileged. It is for the exclusive use of > the > intended recipient(s). If you are not the intended recipient(s) please > note > that any form of distribution, copying or use of this communication or the > information in it is strictly prohibited and may be unlawful. If you have > received this communication in error please return it to the sender or > call > our switchboard on +44 (0) 20 89107910. The opinions expressed within > this > communication are not necessarily those expressed by Reed Exhibitions." > Visit our website at http://www.reedexpo.com > > -----Original Message----- > From: Mike | NZSolutions Ltd > To: CF-Talk > Sent: Thu Nov 09 05:44:48 2006 > Subject: Selecting date from table (for the experts) > > Hi guys, > > I have the following table... > > Season_period > ------------- > Sp_id (PK) > Season_id (FK) > Sp_start_day (INT) > Sp_start_month (INT) > Sp_end_day (INT) > Sp_end_month (INT) > > What I wish to do is select the season_id using a particular date. I am > really not sure how to compare an actual date against just a day/month > value. > > I am going to loop through a series of dates, and wish to know the > matching season_id for a particular date. > > Any ideas on how I should go about building this query would be greatly > appeciated. > > mike > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259749 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
