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:264593
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
