> This did it.
> <cfset CURRENT_DATE = #now()#>
> <cfset today = #now()#>
> <cfset week = #week(today)#>
> <cfset type = "ww">
> <!--- <cfset lastweek = --->
> <cfquery name="weekly" datasource="#application.ds#">
> select * from Skills.completedtest
> where week(date) = #week#-1
> order by date,time
> </cfquery>
>
> But I am confused . why doesnt <cfset week = #week(today)#> set this week to
> this weeks number?
Because week numbering is locale dependent.
Jochem
--
I don't get it
immigrants don't work
and steal our jobs
- Loesje
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
