>>Are there any functions to retrieve the time part of a DateTime field so that a data bound control can display only the time part and be modified by a user?
>>
>>We can't seem to find any such functions, so help is really appreciated...
>
>Hello again,
>
>I think you have to use the HOUR(), MINUTE() and SEC() functions, so you get something like
>
>? PADL(HOUR( DATETIME()), 2, "0") + ":" + PADL(MINUTE( DATETIME()), 2, "0") + ":" + PADL(SEC( DATETIME()), 2, "0")
>
>pretty horrible eh.
Or even just
? RIGHT( TTOC( DATETIME()), 8)
It depends upon how you want to process the time.