|
|
|
|
|
|
|
|
|
|
- Week characteristics
- Special cases
IntegerToWeekNumber (Function) In french: EntierVersNuméroDeSemaine Returns the week number within the year that corresponds to the specified date (this date is an integer).
IntegerToWeekNumber(DateToInteger("20011225")) // Returns 52
Syntax
<Result> = IntegerToWeekNumber(<Date>)
<Result>: Integer Week number (between 0 and 53) that corresponds to the specified date. <Date>: Integer Number of days elapsed since January 1st 1800 + 1 (this number is returned by DateToInteger). Remarks A week starts on a Monday and ends on a Sunday. For the first days of the year: - If the first day of the year is a Friday, Saturday or Sunday, the week number will be 0. Week #1 will correspond to the first Monday of the year.
- If the first day of the year is a Monday, Tuesday, Wednesday or Thursday, the week number will be 1.
- The days between Sunday of the 52nd week and the 1st of January are in week 53.
Business / UI classification: Neutral code
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|