yes... you can do this...
select * from myTable where dateCreated <= myDate and that will work.... so, just implant your dates there, and it will work. tw On Wed, 08 Dec 2004 16:12:38 +0000, Stuart Kidd <[EMAIL PROTECTED]> wrote: > Hi guys, > > I�m trying to find the syntax within a WHERE statement to get all articles > which have deadlines due today or already passed. > > My fields are articleDeadline and my date now is todayUKdate. > > I have seen the DataDiff tag but that only works in a cfif statement. Can I > just say: > > WHERE articleDeadline < todayUKdate? > > Thanks > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186647 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
