>>>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
>>
>
>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.