>>>>>>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.
>Mo,
>
>Rob is trying to using a datetime field, but supress the date portion of it so that the users don't see the date portion of it. He didn't want to use a char or num field because then he would manuall have to check for invalid times (example 12:73).
Use Datetime and TTOD().
Tai SC
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement