>>>>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only