Week number reverse date lookup

HCL Domino Domino Forum
1

If I retrieve a “week number” by way of formula such as the following (provided by a helpful Notes.net User):

tmpLastOf:= @Adjust( Date; 0; 0;

@Select( @Weekday(Date); 6; 5; 4; 3; 2; 1; 0 );0;0;0);

weeknum := @Integer( @If(tmpLastOf=“”;0;1+(tmpLastOf-@Date(@Year(tmpLastOf);1;1))/604800) );

Is there a way to figure out the date range or at least the “beginning date” to which this week number is referring?

An example would be,

Week 2 = Jan 07 2004-Jan 14 2004

or (would also be fine):

Week 2 = Jan 07 2004

Any idea on how to accomplish this?

2

Subject: Week number reverse date lookup

If you start with “Date”, why not just loop through an @Adjust() formula, decreasing the number of days you adjust “Date” by 1 until you find the Monday (or Sunday) preceding “Date”. Then use @Adjust() again, adding 6 to to the first date of the week to find the end of the date range.