I shall over time be publishing articles and tips from the design of all my software. This one comes from the ProjectDX Domino Blog Toolkit and is very quick - a view that displays documents created in the last week.

The View Formula

REM "Calculate week start date from creation field.";

tmpWeek := @Adjust(@Date(creation);0;0;1-@Weekday(creation);0;0;0; [InLocalTime]);

REM "Calculate week start date from today\'s date.";

tmpWeekNow := @Adjust(@Today;0;0;1-@Weekday(@Today);0;0;0; [InLocalTime]);

SELECT form="content" & tmpWeek = tmpWeekNow

Questions? - steve.castledine@projectdx.org