How Do I Retrieve the Name of the Day of the Week of a Given Day? (Magic xpa 2.x)
It can be very difficult to figure out what day of the week a given date falls on, and more work to translate it into text. There is a nice function to do this though, the CDOW() function.

One of the advantages of using this function is that if your application is being distributed in other countries, it will return the date in the user’s chosen language.
Hint: If you need to do computations based on the day of the week, it is better to use a different function, DOW(). This returns a number representing the day of the week, which is easier to use in programs.
The Date Pictures section of the How Do I Convert a Date Value to a String? topic
The syntax of CDOW() is:
CDOW(date)
Where date is any date variable (or a hard-coded date, such as '05/06/2008'DATE, or an expression that evaluates to a date). It returns a string containing the name of the day of the week.
The Online and Rich Client Samples projects (program DT12 and RDT12)