Manage Learn to apply best practices and optimize your operations.

Compute The Week Number In The Month For A Given Date

Some applications require the computation of the week number in a month in
which a given date falls. For example, Sunday 02 May 1999 is in the second week
while Saturday 01 May 1999 is in the first week.

This formula computes the week number of date value GivenDate:

WeekNumber := @Integer( (@Day(GivenDate) - @WeekDay(GivenDate)+13) /7 )

Dig Deeper on Domino Resources - Part 3

  • Favorite iSeries cheat sheets

    Here you'll find a collection of valuable cheat sheets gathered from across the iSeries/ community. These cheat ...