Formula that include Ranages >= And <=

[RachelK]

I am enetering the week from and the week to as a parameter
I have a formula that says:-

If {VIEW_TM_WSTG.WE_NO} >= ToNumber({@WeekFrom}) Then {VIEW_TM_WSTG.WE_NO} Else 0

Which works I would like the Formula to say..

If {VIEW_TM_WSTG.WE_NO} >= ToNumber({@WeekFrom}) And <= ToNumber ({?WeeekFrom})Then {VIEW_TM_WSTG.WE_NO} Else 0

I get an error message saying a number or currenty when I have already changed to number. Any Ideas.

 

[dgillz]

You have a problem with your <= statement. There is no field to the left of <= to compare it to. Your formula should say:

If {VIEW_TM_WSTG.WE_NO} >= ToNumber({@WeekFrom}) And
{VIEW_TM_WSTG.WE_NO} <= ToNumber ({?WeekFrom})Then {VIEW_TM_WSTG.WE_NO} Else 0

Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com

 

[RachelK]

Dgillz,

Thanks so much you have solved my problem thanks for your help.

Cheers agaian.

Rachel.