date falls between a a minimum and maximum date range.

[Almie]

I am using Crystal 10 and need a formula that validates whether a violation date falls between a minimum and maximum date range. Here are my variables:

variable_1: v_voil_date:= violation_date
variable_2: v_from_date:= minimum (effective from_date)
variable_3: v_to_date:= maximum(effectice to_date)

What I need is a formula that IF v_viol_date is between v_from_date and v_to_date then "YES" else "NO"

Also, I need to filter out the "YES" records and only stay with "NO" records. HELP! Thank you in advance!

 

[Almie]

I figured out how to make the "YES" and "NO" appear.

if {@viol_date} in {@v_from_date} to {@v_to_date} then "YES" else "NO"

But, I still can't figure out how to filter out the "YES" records and only stay with the "NO records.

Sincerely

Still need help =o(

 

[lbass]

It is unclear whether you only want to display violatons outside the range, or only those within the range.

Also, please clarify whether you want you to exclude PEOPLE who have any violations within the range or whether you just want to exclude the records that fall within the range. Maybe it would help to describe the purpose of the report.

-LB