Formula for every Monday in a given time period

[TaylorTot]

Does anyone know how to build a formula to pull out every Monday of a given time period. For instance, if my start and end date are 1/1/04-1/31/04, I would like the output to be:

1/5/04
1/12/04
1/19/04
1/26/04

Any help would be greatly appreciated!!!

 

[synapsevampire]

Please supply the version of Crystal and database used.

Does your data contain all of these dates, or do you need to fabricate dates?

Is this all that you need, or are you going to be performing some aggregate functions?

You can create a period table for extracting this, use a SQL Expression or Crystal formula that you could then use to filter only datepart(d,table.date) = 2, and there are other ways.

Rather than asking for help with a function, consider describing your data and requirements more fully.

-k

 

[TaylorTot]

I am creating a report to list all of the reports I run on a monthly basis. One of the reports called MPS is run every Monday. Other reports are run on the first tuesday of the month or based on other criteria.

I'm assuming I will have to fabricate these dates. I have two parameters a start date and an end date.

I am working on Crystal Reports v 8.5 and a database containing all of the reports that need to be run.

Please let me know if you need additional information.

Again I appreciate your help and sorry for the vague post.