Need a function that replace character 1

[EKC]

Hi,
I have a numeric field that need to be converted to time - actually this field show time ex. 15.45 is 15:45.Is there a function that can do this and if not is there a function that can replace a "." with ":"
Ex. Fun(15.45) should return 15:45

Thanks in advance
Lyn

 

[jhall156]

This should do the trick.
ALLTRIM(STR(INT(yournumber))) + ":" + ALLTRIM(STR((yournumber-INT(yournumber))*100))

 

[marsh]

Try this:

FUNCTION ConvertToCharTime()
LPara nNum
RETURN strtran(str(nNum,5,2),".",":&quot

 

[jhall156]

Kewl! I've never used that func.