>>Hi all,
>>I have a date/time field but in the textbox, I only want to get/show the Time. Is there any way I can do this through an input pask or format property or any other way.
>>
>>Thanks & regards
>>
>>Abdul Ahad Khan
>
>Abdul,
>
>Check Time() and TTOC() functions in the Help, I think, they should help you. This is from HELP on TTOC():
>
2
>
>Specifies that TTOC( ) return a Character string consisting of only the time portion of the DateTime expression. The settings of SET SECONDS and SET DATE specify if the seconds portion of the time is included in the character string. Note that if SET DATE is set to LONG or SHORT, the format of the character string is determined by the format of the Control Panel time setting.
>That doesn't address the input issue at all; you need to construct an input composite with two or three segments (hours/min or hours/min/secs) and convert them to a datetime(). My general inclination would be to build a composite object from a container with spinners for each area, and convert to a datetime() when the various control's LostFocus() fired, updating the spinners.