Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SET FDOW doesn't work for me
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01090273
Message ID:
01090291
Views:
9
Sergey and Yuri
? DOW(DATE(), SET("FDOW"))
works perfect
But I read the help. I don't find DOW() function is not affected by SET FDOW
This is in my help
Returns a numeric day-of-the-week value from a Date or DateTime expression.
 
DOW(dExpression | tExpression [, nFirstDayOfWeek])

Parameters
dExpression
Specifies the Date expression from which DOW( ) returns the day number.

tExpression
Specifies the DateTime expression from which DOW( ) returns the day number.

nFirstDayOfWeek
Specifies the first day of the week. nFirstDayOfWeek may be one of the following values.

nFirstDayOfWeek  Description  
0
 DOW( ) uses whatever day is currently selected in the Week Starts On list box, which appears on the Regional Tab in the Options dialog box.
 
1 Sunday. This is the default when nFirstDayOfWeek is omitted, and is the first day of the week used in earlier FoxPro versions.
2 Monday
3 Tuesday
4 Wednesday
5 Thursday
6 Friday
7 Saturday
Yes [, nFirstDayOfWeek] is parameter but why I need to use this parameter while i have SET FDOW TO? or this is dummy SET ??? unusable may be

>According to help, the DOW() function is not affected by SET FDOW. The following should work for you
>? DOW(DATE(), SET("FDOW"))
>
>
>>I read thread#1090152 and I try this code
>>
>>*** today is Wednesday
>>clear
>>SET FDOW TO
>>? DOW(DATE()) &&& result is 4  = true
>>SET FDOW TO 2 &&& Monday is the first day
>>? DOW(DATE()) &&& result is again 4. Why ? Today is Wednesday must by 3
>>
>>What do I wrong?
>>TIA
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform