Difference between revisions of "DOW()"
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Function to return numeric day of the week from a specified date | Function to return numeric day of the week from a specified date | ||
| Line 59: | Line 55: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital Server, Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
| + | [[Category:Date and Time Data]] | ||
| + | [[Category:Date and Time Data Functions]] | ||
Latest revision as of 17:00, 27 November 2009
Purpose
Function to return numeric day of the week from a specified date
Syntax
DOW(<expD> | <expT> [,<expN>])
See Also
AMPM(), CDOW(), CMONTH(), CTOD(), CTOT(), DATE(), DATETIME(), DAY(), DAYS(), DMY(), DTOC(), DTOM(), DTOS(), DTOV(), ELAPTIME(), EPOCH(), GOMONTH(), HOUR(), HOURS(), MDY(), MINUTE(), MINUTES(), MONTH(), MTOD(), QUARTER(), SEC(), SECONDS(), SECS(), SET CENTURY, SET DATE, SET EPOCH, SET HOURS, SET MARK, SET SECONDS, SET VAXTIME, STOD(), TIME(), TIMESTAMP(), TSTRING(), TTOC(), TTOD(), VALIDTIME(), VTOD(), WEEK(), YEAR()
Description
The DOW() function returns a number representing the day of the week from the given date expression <expD> or datetime expression <expT>.
| Return Value | Day of Week |
|---|---|
| 1 | Sunday |
| 2 | Monday |
| 3 | Tuesday |
| 4 | Wednesday |
| 5 | Thursday |
| 6 | Friday |
| 7 | Saturday |
The optional <expN> is used to specify an alternative first day of the week.
Example
set date american ? dow({02/29/2004}) 1 ? dow({02/29/2004},2) 7 store dow({02/29/2004}) to dayofweek ? dayofweek 1 dayofweek = dow({02/29/2004 11:35:27 A.M.}) ? dayofweek 1
Products
Recital Server, Recital
