Spit a field value then concatenate with colon separators 3

[elsenorjose]

Hello all,

I've searched the forum for this but I might not be using the correct terminology because I'm not finding a solution. Basically, I have a field that stores a HH:MM:SS value but with no colon. So, 12:24:59 is literally 122459. I want to take the value and display it as HH:MM:SS. I'm using CR XI R2 on a SQL Server 2005 database.

Thank you.

 

[elsenorjose]

Found the solution. The formula is as follows:

CTime(Picture({field}, "xx:xx:xx"))

Thanks.