The described function (WEEKDAY) does not support weeks starting with Saturday, common in various Muslim countries including Iran.
Extend the function so that it includes a value for "weekday-start-flag" that relates to a weekday numbering convention that starts with Saturday.
Part 4, 3.17.7.341
te
Proposed Disposition of DIS 29500 Comment IR-0003 (Modified: 2007-12-07) We agree that the issue raised is valid, and the following changes will be made: Part 4, §3.17.7.341, page 2,819, line 5: Arguments: Name Type Description weekday-start-flag Number When truncated to integer, indicates the weekday numbering convention to be used, as follows: Value Meaning 1 or omitted 1 (Sunday) through 7 (Saturday) 2 1 (Monday) through 7 (Sunday) 3 0 (Monday) through 6 (Sunday) 11 1 (Monday) through 7 (Sunday) 12 1 (Tuesday) through 7 (Monday) 13 1 (Wednesday) through 7 (Tuesday) 14 1 (Thursday) through 7 (Wednesday) 15 1 (Friday) through 7 (Thursday) 16 1 (Saturday) through 7 (Friday) 17 1 (Sunday) through 7 (Saturday) Part 4, §3.17.7.341, page 2,819, lines 1415: [Example: WEEKDAY(DATE(2006,2,1)) results in 4 (Wednesday) WEEKDAY(DATE(2006,2,1),1 1 ) results in 3 4 (Wednesday) WEEKDAY(DATE(2006,2,1), 1 2) results in 2 3 (Wednesday) WEEKDAY(DATE(2006,2,1),3) results in 2 (Wednesday) end example]
