|
|
|
|
|
|
|
|
|
|
- Week characteristics
- Special case
DateToWeekNumber (Function) In french: DateVersNuméroDeSemaine Returns the week number within the year that corresponds to the specified date.
DateToWeekNumber("20011225") // Returns 52
Â
MyDate is Date = Today()
DateToWeekNumber(MyDate)
Syntax
<Result> = DateToWeekNumber(<Date>)
<Result>: Integer Week number (between 0 and 53) that corresponds to the specified date. <Date>: Character string, 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 the year, MM to the month, DD to the day, HH to hours, mm to minutes, SS to seconds and CC to hundredths of a second (use CCC for thousandths of a second)). 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 Week characteristics 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.
Remark: To get a week number corresponding to the ISO 8601 standard, use WeekNumber. Special case The date 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…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|