| Description |
CDOW (Magic xpa 3.x)
|
Returns the name of the day (e.g., Sunday, Monday) from a date or a date expression.
| |
Syntax:
|
CDOW(date)
| |
Parameters:
|
date: A date or a date expression.
| |
Returns:
|
Day of week in character string.
| |
Examples:
|
CDOW('01/28/92'DATE) returns 'Tuesday'
Where x contains, in effect, the date 01/28/92 (Tuesday), then CDOW(x+1) returns 'Wednesday'
| |
Note:
|
The use of DATE following '01/28/92' identifies the string as a DATE literal string, and should not be confused with the Date() function.
You can control the length of the day name by manipulating the length of the Alpha column that will hold it. For example, if you update a 3-character Alpha column with the result of a CDOW operation, Magic xpa displays the first three letters of the day name (e.g., 'Mon', 'Tue').
| |
See also:
|
Day, DOW, NDOW
How Do I Retrieve the Name of the Day of the Week of a Given Day?
The Online and Rich Client Samples projects (program DT12, DT19, RDT12 and RDT19)
|
|
|
|---|
