>>>>>I want to display and edit the time part of the datetime field.
>>>>>How can I substr the time part?
>>>>
>>>>? substr(ttoc(datetime()),10)
>>>thanks Ed -
>>>thanks work
>>>?substr(ttoc(date_time),11)
>>>the display is : 12:45:00 AM
>>>Now I want to take off the last two zeros and just display and edit
>>>this :12:45 ?
>>
>>Open help and read about SUBSTR(), please.
>-------
>hey ed..
>I have a fld call time_val and is a ch 8. In this field I have an Input Mask
>of 99:99 !! - I would like the !! to be either AM or PM. Can you help with this.
>thanks :)
You better use two separate textboxes.
Edward Pikman
Independent Consultant