Show a period in a Document

[amber2000]

Hello everybody,

I would like to know how I can Show data for every monday in a particulare month?

Goal is to compare the data of a monday to another monday.

In my script I have already date, week, month, year and current selection.

ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

SET MoneyFormat='€ #.##0,00;€ -#.##0,00';

SET TimeFormat='h:mm:ss';

SET DateFormat='D/MM/YYYY';

SET TimestampFormat='D/MM/YYYY h:mm:ss[.fff]';

SET MonthNames='jan;feb;mrt;apr;mei;jun;jul;aug;sep;okt;nov;dec';

SET DayNames='ma;di;wo;do;vr;za;zo';



LET CurrentDate = Num(Today());

LET CutOffDate = Date(CurrentDate - 7,'YYYYMMDD');

LET CutOffYear = Date(YearStart(CurrentDate,-1),'YYYYMMDD'); /* Begin vorig jaar */

LET CutOffMonth = Date(AddMonths(CurrentDate,-1),'YYYYMMDD'); /*1 maand terug */

Can anybody help me with this issue please?

Ambertje

[Josh_Good]

I would recommend creating a master calendar which includes day of the week.  You can then just select on "Monday" and see all the Mondays.

Re: Creating A Master Calendar

[#3]

Try with WeekStart () function. See The help for instructions of use.

mario