Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I get the day?
Message
From
30/05/2014 13:01:40
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
30/05/2014 11:45:56
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows NT
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01600946
Message ID:
01601000
Views:
63
>>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform