Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Option for date of week
Message
From
11/10/2005 09:50:59
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01057746
Message ID:
01057932
Views:
13
>>>I have option group with days of week (only Monday through Friday). I have nDow in my table. How can I bind this optiongroup to my field's value, if nDow for Monday is 2?
>>>
>>>Thanks in advance.

AFAIK it can't be done. The trick you described below is the best I can think of in this case.

>>
>>Look at
DOW(datefield, 2)
>
>Not sure how does this help me. I guess, I didn't explain my need very well. I have a numeric field in a table called nDow. I want to show options with days of weeks
>Monday Tuesday ... Friday and have my field to be a controlsource for the option group. Borislav and me both have the same idea of adding invisible Sunday to the option group. This way the second available and visible option Monday will be saved as 2 in my table (exactly what I want, since a week starts with Sunday).

Lennert
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform