Zoran Zivkovic wrote:

> --- In firebird-support@yahoogroups.com, John vd Waeter <john@...>
> wrote:
>
>>Zile,
>>
>>What if you change date from 10.3.2007 to 10.03.2007 ?
>>
>>and, if that not helps, what if date between 10.03.2007 and
>
> 10.03.2007 ?
>
>>regards,
>>John
>>
>
>
> I Tried it, it is not solution. returning values for 10.3.2007 are
> OK. It occurs when I try to make query with big diference between
> dates - I think becasue returning value can't fit field definition.
> When I look for March, everything is fine.
>
> Regards
>
> Zile

And if you change

Sum(I_CENA*I_KOL*(1-(F_KASP/100.00))*((100-I_RAB)/100)) AS VP

Into

Sum(I_CENA*I_KOL*(1-(F_KASP/100.00))*((100-I_RAB)/100.00)) AS VP

??