[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
DOW()
Convert a date value to a numeric day of the week
------------------------------------------------------------------------------
Syntax
DOW(<dDate>) --> nDay
Arguments
<dDate> is a date value to convert.
Returns
DOW() returns the day of the week as a number between zero and seven.
The first day of the week is one (Sunday) and the last day is seven
(Saturday). If <dDate> is empty, DOW() returns zero.
Description
DOW() is a date conversion function that converts a date value to a
number identifying the day of the week. It is useful when you want date
calculations on a weekly basis. DOW() is similar to CDOW(), which
returns the day of week as a character string instead of a number.
Examples
. These examples illustrate CDOW() and its relationship to
DOW():
? DATE() // Result: 09/01/89
? DOW(DATE()) // Result: 3
? CDOW(DATE()) // Result: Tuesday
? DOW(DATE() - 2) // Result: 1
? CDOW(DATE() - 2) // Result: Sunday
. This is a user-defined function that uses DOW() to calculate
the date of last Monday from any other date:
FUNCTION LastMonday(dDate)
RETURN (dDate - DOW(dDate) + 2)
Files Library is CLIPPER.LIB.
See Also:
CDOW()
DATE()
DAY()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson