Creating a weekly variable

[TaylorTot]

I am creating a report that is supposed to be like a timeline. I have a report that is supposed to be run every Monday. I currently am using a start date and end date for parameters and it will be run on a monthly basis. Is there a formula out there that will give me every monday in a month?

Let me know if you need more details.

Thanks for your help in advance!!

 

[goranm]

Hi !

Try this in your record selection:

{YourDate}in LastFullMonth and
weekday({YourDate}) = 2


/Goran

 

[TaylorTot]

Wow, thank you for the quick reply.

When I put that in my record selection all I see is False.

I will provide more background. . .

I would like to create a list of reports to be run in a given Month.

One of the reports is run every Tuesday of the month so I used this formula:

//Finds the First Tuesday of every month based on the start date

WhileReadingRecords;
DateVar BOM:= {?Start Date} - Day({?Start Date})+6;
DateVar BOW:= BOM - DayOfWeek(BOM)+3

Then I've added that to this formula:

//Displays Rundates

If {Reporting.Report}="Activity Report" then {@FirstTuesdayofeverymonth}

So that all works fine. . .

Now I have a report (MPS) that is supposed to run every Monday. . .

This is an example of the output I would like to see for December. . .

MPS 12/1/2003
MPS 12/8/2003
MPS 12/15/2003
MPS 12/22/2003
MPS 12/29/2003
Activity Report 12/2/2003

Do you have any advice on how to create such a formula?

Again thank you so much for whatever assistance you can provide