>>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).
He is specifying that Monday is the first day of the week
Gregory