Hello,

I am looking for some help on how to convert the time portion of a DateTime field to alphanumeric format of HHMMSS. I am currently using the HCNVRT function to extract the time from the DateTime field. This returns the time in HH:MM:SS format

e.g. HCNVRT( RecordDateTime , '(HHIS)' , 8 , 'A8' )
returns 17:23:32

However, I would like to strip out the colon characters, and return HHMMSS instead.
e.g. 172332

Any help on this would be greatly appreciated.

Thanks!

This message has been edited. Last edited by: Kerry,

Welcome to the forum....



Why not just EDIT the result.

e.g.
EDIT(HCNVRT( RecordDateTime , '(HHIS)' , 8 , 'A8' ),'99$99$99')

Function HPART or function HNAME may also work.

Thanks Waz! That worked perfectly! I kept thinking in terms of date functions, it never occurred to me to use EDIT.

Thanks again!