>Dear All,
>I have the following problem: When I run the code below (The code is to produce a list of week no's
>with the two last figures in the corresponding year as a prefix)
>
>CREATE CURSOR curWeekNo(weekno N(4,0))
>SELECT 'curWeekNo'
>FOR i=1 TO 6
>REPLACE curWeekNo.weekno WITH ;
> ROUND(VAL(SUBSTR(ALLTRIM(STR(YEAR(DATE()+7*(-6+i)))),3))*100+;
> WEEK(DATE()+7*(-6+i),0,2),0)
>NEXT
>Today (6th of January 2012) in the VFP developing environment I get the correct result as follows
>1148
>1149
>1150
>1151
>1152
>1201
>
>When I run the same code in the exe-file I receive the result
>1149
>1150
>1151
>1152
>1101
>1202
>
>Any idea?

This will depend on the first day of the week (see SET FDOW in Help).