In SQL it would be SELECT * FROM yourTable WHERE yourDate BETWEEN startDateColumn AND endDateColumn
In CF it would be <cfif dateCompare( date1, date2 ) EQ 1 > date 1 is greater thandate 2 Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development > -----Original Message----- > From: DIEDLER Alexander [mailto:[EMAIL PROTECTED] > Sent: Monday, 26 September 2005 4:59 PM > To: CF-Talk > Subject: comparing dates > > > Hello, > I have to create a appliaction with time based visibility. So > I have a start date and end date for the period in which the > article should be visible. How can I check, if the actual > sysdate is between the start and end date or out of this range? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219223 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54