I am using Crystal 10.

How would you calculate a date range if given the request:

Quote:

I want a report of all males between 18 - 50 years of age.

TIA,
~RLG
 

Create a formula {@age} as shown here: http://www.kenhamady.com/form06.shtml
and then use a record selection formula like:

{table.gender} = "M" and
{@age} in 18 to 50

-LB

Hi LB,

That got me started but I have run into a hiccup.  I added the code on Ken Hamandy's page in the @age function using

I placed this Formula on the report and it seems to be calculating correctly and sees it as a number.

But when I reference it in the record selection formula like this:
@age in (18.00 to 50.00)

It says there is an error in the formula:

Quote:

A number, currency amount, boolean, date, time, date-time, or string is expected here

I have tried several ways of asking this question, such as:
@age >= 18 and @age <= 50
And they all get the same error message. When I mouse over it on the report is says it is a number so I don't understand why it gives this error.  Any suggestions?

TIA,
~RLG
 

You are not showing the entire formula from Ken's page. Please show the actual formula you used for {@age} if it contained more that what you are showing above.

-LB

Good morning!

Here is the entire formula:

Did I miss anything?

~RLG
 

Just noticed that you didn't use square brackets, but you don't need any at all:

@age in 18 to 50

And you don't need decimals, since the result is always a whole number. If you did want to use brackets, it would be:

@age in [18 to 50]

-LB
 
 

Argh! I just figured out what was wrong.  I did not have the curly braces around @age! So at least I can save it.  Now to test it to see if it works!

Thanks for all your help!

~RLG