Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
First day of the week
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00941538
Message ID:
00941545
Views:
8
This message has been marked as the solution to the initial question of the thread.
Bernhar when I read Your first post more carefully I realise that You want to know the first day of the week of some date not the number of the day of the week:
Try this (not tested):
 FUNCTION FirstDay(dDate)

 LOCAL ret_val
 IF DOW(dDate) == 1
    ret_val = dDate - 6             && To make it Mondey not Sunday
 ELSE
   ret_val = dDate - DOW(dDate) + 2 && To make it Mondey not Sunday
 ENDIF

RETURN CDOW(ret_val) + " "+ DTOC(ret_val)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform