Help / WLanguage / WLanguage functions / Standard functions / Date and time functions
  • Week characteristics
  • Special cases
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Stored procedures
Returns the week number within the year that corresponds to the specified date (this date is an integer).
IntegerToWeekNumber(DateToInteger("20011225")) // Returns 52
<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).

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.
Universal Windows 10 AppAndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystJava

Special cases

This function cannot be used to retrieve week numbers from dates before October 14, 1582 (the change from the Julian to the Gregorian calendar will not be taken into account).
Business / UI classification: Neutral code
Component: wd290std.dll
Minimum version required
  • Version 9
This page is also available for…
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help