if your database supports BETWEEN, you can select foo from my_tbl where my_date between start_date and end_date
or are you wanting to do that in ColdFusion? On Fri, Aug 1, 2008 at 12:46 PM, <[EMAIL PROTECTED]> wrote: > Hey all. > > I've got a fiscal year that runs from July of a year to June of the next > (July 2008 to July 2009). In the body of the application that I'm runnng I > have a list of categories that will change when the fiscal year changes. > > I need to find out if now() falls in the current fiscal year and set a date > variable that will be passed to a query to get the categories. > > Does anyone have a code snippet that determines if a date falls in between > two other dates? > > Thanks > > sas > -- > Scott Stewart > ColdFusion Developer > http://www.sstwebworks.com/blog > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310064 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
