And, of course, make sure you put the dates in the right order in the SQL. ;)
cheers,
barneyb
On 9/21/05, Barney Boisvert <[EMAIL PROTECTED]> wrote:
> endDate = dateAdd("s", -1, createDate(year(now()), month(now()), 1));
> startDate = createDate(year(endDate), month(endDate), 1);
>
> SELECT *
> FROM table
> WHERE timestamp BETWEEN #endDate# AND #startDate#
>
> Don't forget your CFQUERYPARAMs
>
> cheers,
> barneyb
>
> On 9/21/05, Claremont, Timothy <[EMAIL PROTECTED]> wrote:
> > My records get time stamped when they are entered. It is a simple
> > date/time field.
> >
> > What is the correct syntax for retrieving ALL records entered LAST
> > MONTH.
> >
> > So, if today (Now()) is ANY day in September, show me all the records
> > entered in August.
> >
> > TIA,
> > Tim
> >
>
--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/
Got Gmail? I have 100 invites.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218830
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
