CRYSTAL REPORT： FORMULA 的 DATE BETWEEN 问题

winterain

我有一个CRYSTAL REPORT 的问题。。

我做了一个FORMULA："@forecast":

numberVar forecast := 0;

if {SCHEDULE_BILLING.STATUS_1}="F" and Date({SCHEDULE_BILLING.BILLING_DATE_1}) <= {?ForecastTo} and Date({SCHEDULE_BILLING.BILLING_DATE_1}) >= {?ForecastFrom} then
forecast := {SCHEDULE_BILLING.VALUE_1};

if {SCHEDULE_BILLING.STATUS_2}="F" and Date({SCHEDULE_BILLING.BILLING_DATE_2}) <= {?ForecastTo} and Date({SCHEDULE_BILLING.BILLING_DATE_2}) >= {?ForecastFrom} then
forecast := forecast + {SCHEDULE_BILLING.VALUE_2};

if {SCHEDULE_BILLING.STATUS_3}="F" and Date({SCHEDULE_BILLING.BILLING_DATE_3}) <= {?ForecastTo} and Date({SCHEDULE_BILLING.BILLING_DATE_3}) >= {?ForecastFrom} then
forecast := forecast + {SCHEDULE_BILLING.VALUE_3};

if {SCHEDULE_BILLING.STATUS_4}="F" and Date({SCHEDULE_BILLING.BILLING_DATE_4}) <= {?ForecastTo} and Date({SCHEDULE_BILLING.BILLING_DATE_4}) >= {?ForecastFrom} then
forecast := forecast + {SCHEDULE_BILLING.VALUE_4};

if {SCHEDULE_BILLING.STATUS_5}="F" and Date({SCHEDULE_BILLING.BILLING_DATE_5}) <= {?ForecastTo} and Date({SCHEDULE_BILLING.BILLING_DATE_5}) >= {?ForecastFrom} then
forecast := forecast + {SCHEDULE_BILLING.VALUE_5};

if {SCHEDULE_BILLING.STATUS_6}="F" and Date({SCHEDULE_BILLING.BILLING_DATE_6}) <= {?ForecastTo} and Date({SCHEDULE_BILLING.BILLING_DATE_6}) >= {?ForecastFrom} then
forecast := forecast + {SCHEDULE_BILLING.VALUE_6};



this formula is to sum the schedule billing's value as @forecast if the schedule billing date is between the ForecastFrom and ForecastTo.

But if the later schedule billing, for eg:BILLING_DATE_6 is not between the date, it will return the result for @forecast as 0.

请问是什么问题呢？谢谢