If you're wanting coldfusion to check, you could do something like:
<cfset mydate = now() />
<cfset sDate = CreateDate(year(now()),7,1) />
<cfset eDate = CreateDate(year(now())+1,7,1) />
<cfoutput>
sdate = #sdate#<br />
edate = #edate#<br />
</cfoutput>
<cfif mydate gte sdate and mydate lt edate>
It's there<br />
<cfelse>
Nope<br />
</cfif>
On Fri, Aug 1, 2008 at 12:58 PM, Greg Morphis <[EMAIL PROTECTED]> wrote:
> 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:310065
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
