>>But according to my calendar, sunday the 19th of october is in week 42.

This might be a so called "Business calendar", in which weeks start on 
Monday,
but in civil calendars, a week always start on sunday.

What you want really is having the standard weeknumber, except when the 
date is a Sunday,
in which case you want weeknumber -1, since you consider this day to be 
the last day in
previous week.

Then try this :
DatePart("ww",myDate-1)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315300
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Reply via email to