Yes Chris, sorry. Here was my response to you:
Hi Chris,
Thanks for the info!
....only I still get 0 records. It seems it's trying to search a specific time
now:
where timereceived between {ts '2006-12-19 11:26:17'} and {ts '2006-12-20
11:26:17'}
Anyway to ignore/remove the time?
-----Original Message-----
From: Christopher Jordan [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 20, 2006 11:41 AM
To: CF-Talk
Subject: Re: time/date format in Access
Robert, have you looked at the idea I shot out? I really think it will
work for you, and it also reduces all that month1, month2, year1, year2,
etc. code down to two lines of code.
Lemme know if it helped, or if you didn't get the post for some reason.
Cheers,
Chris
Orlini, Robert wrote:
> Thanks Charlie for the valued advice, I remember you brought that out
> yesterday. I didn't forget. As soon as I get this thing running I will revise
> my poor code habits on this and remember it for future reference. I know some
> names I'm using would crash SQL.
>
> -----Original Message-----
> From: Charlie Griefer [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, December 20, 2006 11:16 AM
> To: CF-Talk
> Subject: Re: time/date format in Access
>
> btw this:
>
> <cfset month = #dateformat(now(),"mm")#>
> <cfset year = #dateformat(now(),"yyyy")#>
> <cfset year2 = #dateformat(now(),"yyyy")#>
> <cfset month2 = #dateformat(now(),"mm")#>
> <cfset day = #dateformat(now(),"dd")#>
> <cfset day2 = DateFormat(Now(),"dd")-1>
>
> is easier done as:
>
> <cfset month1 = month(now()) />
> <cfset month2 = month(now()) />
> <cfset year1 = year(now()) />
> <cfset year2 = year(now()) />
> <cfset day1 = day(now()) />
> <cfset day2 = day(now() - 1) />
>
> and really (again), using 'month', 'day', and 'year' as variable
> values is a bad idea.
>
> On 12/20/06, Steve Brownlee <[EMAIL PROTECTED]> wrote:
>
>> Now that I think about it, you may want to use the day of year instead
>>
>> <cfset day2 = DateAdd('y', -1, Now())>
>>
>>
>> Steve Brownlee
>> http://www.fusioncube.net/
>>
>> -----Original Message-----
>> From: Orlini, Robert [mailto:[EMAIL PROTECTED]
>> Sent: Wednesday, December 20, 2006 11:00 AM
>> To: CF-Talk
>> Subject: RE: time/date format in Access
>>
>> Hi Steve, thanks, but got a: "dd" is not a valid date/time format.
>>
>>
>>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264609
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
