|
|
|
|
|
|
|
|
|
|
- Characteristics of the weeks
- Special case
DateToWeekNumber (Function) In french: DateVersNuméroDeSemaine Returns the number of the week corresponding to the specified date.
DateToWeekNumber("20011225") // Returns 52
MyDate is Date = Today()
DateToWeekNumber(MyDate)
Syntax
<Result> = DateToWeekNumber(<Date>)
<Result>: Integer Number of the week (between 0 and 53) corresponding to the specified date. <Date>: Character string (with quotes), Date or DateTime variable Date to use. This date can correspond to: - a character string in YYYYMMDD format (YYYY corresponds to the year, MM to the month and DD to the day).
- a character string in YYYYMMDDHHMMSSCC format (YYYY corresponds to year, MM to month, DD to day, HH to hour, MM to minutes, SS to seconds and CC to hundredths of a second (use CCC for milliseconds). In this case, only the date is taken into account.
- a Date variable.
- a DateTime variable. In this case, only the date is taken into account.
Remarks Characteristics of the weeks A weeks 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. The 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 found between the Sunday of the 52nd week and January 1st are part of week 53.
Remark: To get a week number corresponding to the ISO 8601 standard, use WeekNumber. Special case The storage format allows you to store dates from 01/01/0001 to 12/31/9999. Business / UI classification : Neutral code
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|