hi,
plan is character type at mytable, inside this field you can see 04:45:00,

>So plan is numeric? If so, you must check why. The SUBSTR() function won't work with numeric data! Also LEFT() and VAL() won't work!
>
>
>>hi,
>>i get result 0.00,
>>thanks.
>>>Then replace it with a W I D E field with just plan as expression, because we are all curious to know what really causes your problem!
>>>
>>>>hi,
>>>>i write the expression in the report field ,
>>>>i try VAL(SUBSTR(plan, 7, 2)) ,same thing ****
>>>>thanks.
>>>>
>>>>>wiat.....
>>>>>this is what you wrote:
>>>>>
>>>>>>>>under reportexpression-->expression(plat),format ##:##:## ,common
>>>>>>>>VAL(left(plan, 2))*3600 + VAL(SUBSTR(plan, 4, 2))*60 + VAL(SUBSTR(plan, 7, 2))
>>>>>
>>>>>did you write the expression in the report field or you diddefine report variable as I adviced?
>>>>>
>>>>>if it does not work in a whole, you'll need to divide the expressiom on parts and check every one separately.
>>>>>try to write only VAL(SUBSTR(plan, 7, 2)) in the expression and look what result will this give you