Time cal error -urgent

[teccum]

Hi,
I could not run my report and get an error or warning like

"Hour must be between 0 and 23"

for my formula calculation.

My formula for Y is
Y = Time (Truncate ({@X}/60), Remainder ({@X},60),00)

My formula for X is

((ToNumber (left ({CDMAB.TIME_IN}, 2))) * 60) + (ToNumber (mid ({CDMAB.TIME_IN}, 4, 2))*60)

Any one knows why I get this error message. Am I doing something wrong in my formula calculation.

thanks in advance.

teccum

 

[pgtek]

hi
read this

http://support.businessobjects.com/...x_ver=&index_lang=&indexq2=&indexq3=&indexq4=

cheers

pgtek

 

[pgtek]

Hi
check this out

http://support.businessobjects.com/...x_ver=&index_lang=&indexq2=&indexq3=&indexq4=

cheers

pgtek

 

[teccum]

Hi Pgtek,

Thanks for giving me the link info. I will go through that.

thanks
tec

 

[lbass]

Can you provide some samples of what the string field {CDMAB.TIME_IN} returns?

-LB