Thanks all,
the #dateAdd('d', -1, Now())#
does what I need in both instances!
:)
On 23 May 2007, at 13:45, Scott Stroz wrote:
> To get forthcoming:
>
>> #dateAdd('d',-1, Now())#
>
> To get previous events from yesterday back
>
> < #Now()#
>
> You might want to look at the specific date functions for the DB
> you are
> using. I prefer to let the DB do any work it can rather than CF.
> As long
> as the business rules for what needs to be returned will not
> change, I'd
> rather have the DB figure out the date I need.
>
> On 5/23/07, Tom King <[EMAIL PROTECTED]> wrote:
>>
>> Ah ok,
>> forgot to mention the time stamp I'm checking against won't have
>> times, i.e 00:00:00 etc.
>>
>> So I need to do two things:
>>
>> One, get past events, two get forthcoming events:
>>
>> Past events has to get everything "yesterday" (by date) backwards,
>> and forthcoming has to include today forwards:
>>
>> So for each of them, I just can't the syntax right to literally add
>> or remove a day?
>>
>>
>> T
>>
>>
>>
>> On 23 May 2007, at 13:28, Kris Jones wrote:
>>
>>> This is one way of doing it. But watch out. Got bit by some old code
>>> that used this approach on the switch to daylight savings time. It's
>>> better to add a day, then subtract a second.
>>>
>>>> If you want to check until midnight today:
>>>>
>>>> SELECT * from request.events WHERE EventDate <
>>>> #createDateTime(Year(Now()),Month(Now()),Day(Now()),11,59,59)#
>>>>
>>>> Also, you might want to use <cfqueryparam> to pass in the value to
>>>> SQL.
>>>>
>>>
>>>
>>
>>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7.
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278970
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
