l Message-
From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 19, 2001 4:51 PM
To: CF-Talk
Subject: RE: Weekly Date Driven Content in Cold Fusion?
Assuming your database contains a date field use the BETWEEN function in
your SQL to select records dated between Now() (ie: to
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
put two date fields in your database, start_date and end_date.. set the
values for each set of content 5 days apart.. or however far apart you wish.
use SQL like
createodbcdate(now()) BETWEEN start_date AND end_date
At 02:12 PM 4/19/01 -0700, you wrote:
>Is there a way to do a date range from st
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
"s
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
"s
5 matches
Mail list logo
