[RESOLVED] CR Report Between 2 Dates?

[Besoup]

Hi,
I am trying to set up a report that takes 2 dates as parameters and will report everything between them. I have one field called birthdays and I want the report to show them all between the 2 dates that the user gives.

Anyone Know how I would set this up?

[RobDog888]

You can either set it in the SelectionFormula or by filtering your datasource object.

[Besoup]

Actually I messed up... I need the parameter to be a month and report to show all the of the records with that month in the birthday field. Passing the parameter shouldn't be a problem. The problem lies in the syntax of the expression I think....

Any ideas?

[RobDog888]

Can you post your code? I have some code on the forums for passing parameters for the report.

[brucevde]

The record selection formula in Crystal would simply be (assuming @Month parameter is the month number)

Month ({TableName.BirthDate}) = {?@Month}

[Besoup]

The record selection formula in Crystal would simply be (assuming @Month parameter is the month number)

Month ({TableName.BirthDate}) = {?@Month}

This works thanks guys.