| Compute the Week Number in the Month for a Date |
Tripp W Black on 10/17/2000 at 04:37 PM |
Category: Notes Developer Tips
Forms/Subforms, Formulas
|
From the Advisor via SearchDomino Email
By Nagendra Rentala
Perth Amboy, NJ, 08861 - 3666
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 )
previous page
|