Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How do I get the day?
Message
De
30/05/2014 13:01:40
Mike Yearwood
Toronto, Ontario, Canada
 
 
À
30/05/2014 11:45:56
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows NT
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01600946
Message ID:
01601000
Vues:
61
>>>From a digit (1 to 7) how do I get the day? I forgot if there is a native function in Fox to do that.
>>>
>>>For example
>>>
>>>GiveMeTheDay( 2) would give a result of "Monday"
>>
>>Try
>>
>>FUNCTION cWeekDay
>> LPARAMETERS;
>>  tnDayNumber
>>
>> RETURN CDOW(DATE()-DOW(DATE(),0)+tnDayNumber)
>>ENDFUNC &&cWeekDay
>>
>
>If you omit the Function wrapper, this is a true one-liner. I like this (and it seems I did write one like that years ago).
>
>We didn't have a good date challenge here for months. This refreshed my day.

If that fires so the first DATE() is before midnight 23:59:59.999 and the second DATE() is on or after midnight - so it is the next day, the result will be wrong.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform