Home > lang > week 
 fr de es it nl pl pt pt_BR mk sq ca ar fa vi ja ru zh zh_TW eo
Previous  Next  Edit  Rename  Undo  Refresh  Search  Administration  
Documentation
History
 
Week
Syntax
Result = Week ( Date AS Date [ , FirstDayOfWeek AS Integer , FullWeek AS Boolean ] )

Returns the week number from a given date.

Anyway, this function can return zero if we are before the first week of the year.

By default, the first day of the week is Monday, and partial weeks are counted.

Examples

PRINT Week("07/24/2005")

29

PRINT Week("01/01/2005")

0

PRINT Week("01/01/2004")

1

See also

Date & Time Functions