I have time stamps, when I select the max i get 00:22:49.2930000 -- I would like to display this as 00:22:49.29 how can this be accomplished? when I set the textproperty as time HH:mm:ss, the decimal places remain. is there a way to change the length of this value? I've also tried stating it as a number with 0 or 2 decimal places and get no change. -- i've also tried a substring which gave me an error, my expression is =Max(Fields!TimeDiff.Value) any help appriciated. Thanks, Mike

00:22:49.29 <- If this is always going to be 11 characters then just convert to string, and take the left 11 characters :- = Left(CStr(Fields!blah.value),11)

how does MAX fit into that expression? I tried using substring and got an error

Hi, Just add max in what siad in first post by Josh = Left(CStr(Max(Fields!TimeDiff.value)),11)- Chintak (My Blog)