Of course!
try somethig like this:
<cfquery name="..." datasource="...">
select * from mytable where start_date <= #createodbcdate(now())# and
end_date >= #createodbcdate(now())#
</cfquery>
Alejandro Mozo Quesada
Sistemas / Programaci�n
http://www.tiza.net
educar divirtiendo
----- Original Message -----
From: "SHEETS, DAYV (PB)" <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Thursday, April 19, 2001 8:14 PM
Subject: Weekly Date Driven Content in Cold Fusion?
> Is there a way to do a date range from start to end (e.g. a five day
span)?
> I want to be able to have content automatically change every week from
> information being stored in a database. The information will be displayed
> only if it falls within that date range criteria (I would build two fields
> "start_date" and "end_date".
>
> Is something like this possible in Cold Fusion?
>
> TIA,
>
> Dayv
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
