Formula to determine if date falls within two dates?

[stcholly]

I'm trying to write a formula (V.10) that says:

if {amount} <field> in [x,y,z] and
if {accounting date} <field> is between {firstdayofyear} <formula> and {cutoff date} <formula>

then {amount} <field>

I'm struggling with the second part of the formula that determines if it falls within the date range....(I'm relatively new to Crystal)

 

[Turkbear]

Hi,
Assuming your formulas do what you want then try:

if (
{amount}  in [x,y,z]
 and
{accounting date}  IN {@firstdayofyear} TO
{@cutoff date}  
)
then
{Amount}

To Paraphrase:"The Help you get is proportional to the Help you give.."