Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
First day of the week
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00941538
Message ID:
00941545
Vues:
9
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform