Get date value from crystal report

Question

I've get value "SDFE12:56" from database, but in my report, i only want to show 12:56 under the colume Time. Is there a way to do that? I've already tried by Ctime()function. but it seems not working

thanks

Answer 1

In the same lay as your other question

Mid ("SDFE12:56",4 ,5 )

or because it is at then end you can do

Mid ("SDFE12:56",4)

Answer 2

try val function

val(SDFE12:56)

if you want check link