>>>>I am writing a program and I need a TIME IN field and
>>>>a TIME OUT field. I know I could use VALIDS and check
>>>>the user entry, but I thought that vfp50 might have
>>>>some built in stuff. Any ideas?
>>>
>>>Robert,
>>>
>>>I am just thinking off of the top of my head here...
>>>
>>>You could use a datetime field and then either fill the date portion with null or you could use the entire field. Your program would then have a time and date for the start of the appointment (TIME_IN) and time and date for the end of the appointment (TIME_OUT). It would be a more general solution to scheduling.
>>>
>>>You would then be using a field that is fundamentally of type "time" and foxpro would handle much of the error checking.
>>>
>>>Someone jump in here if this suggestion is totally wrong, but I pretty sure this should work.
>>
>>hay Evan:
>>I tried it and if I could get rid of the date, it might work.
>>I do not need the date, only TIME IN and TIME OUT. I am not
>>aware of a way to substr a field. any ideas?
>>thanks..rob
>
>Rob,
>
>You might want to check out the format statement, perhaps you can suppress the date portion using that. There must be a way. Let's just hope one of these foxpro gurus jump in.

Use TIME() by itself.