Depending on how your dates are configured in the database, you may
need to artificially add a day to produce the desired results.
<cfset myDate = dateAdd("h", 24, now())>
SELECT *
FROM mytable
WHERE dateDue <= myDate
On Wed, 8 Dec 2004 11:27:35 -0500, Tony Weeg <[EMAIL PROTECTED]> wrote:
> 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 Silver Sponsor - New Atlanta
http://www.newatlanta.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186693
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
