string to time format 1

[MartUK]

I am using CR XI
I have a string field relating to time 8 characters long wich I need to convert to time

eg 07181244

left({FSCACT.FSCACT_CREATE_TIME},4) gives 0718 which I need to convert to 07:18:00. How can I do this please?

 

[lbass]

Use:

time(val(left({table.string},2)),val(mid({table.string},3,2)),val(mid({table.string},5,2)))

Or if you want to show seconds as zero, use:

time(val(left({table.string},2)),val(mid({table.string},3,2)),0)

-LB

 

[MartUK]

thanks this worked great