>I suppose when you think of it in those terms, it sort of makes sense. Of course, I also suppose that then all the combinations should be possible - only show Time without date etc.

Yes, I agree. But, instead of having a ton of functions, if they had date specific format or input codes like YMD HTS (t more minute) or something... then you could just define the mask as you want. Just a thought.

>
>I guess it depends on the purpose for which it's needed.
>
>Alan
>
>>YOu can turn of whether a VFP textbox displays the seconds, why not the full time. I think it is a little different. But, as you say, I will 'deal' with it.
>>
>>>I'm guessing that they expected that the user input controls would reflect the data as it is. I don't see that what you're suggesting is really any different than saying that there should be a simple way to set a textbox controlsource to only deal with the 1st (or middle, or whatever) 5 characters of a 15 character field. I doubt it comes up much, and when it does, we just have to improvise.
>>>
>>>Alan
>>>
>>>>Yep, that's basically what I am going to do. I can't belive there is no way to set a text box to only display/edit the date portion of a date time field. I guess cause VFP has a date type they never thought this was needed.
>>>>
>>>>>I doubt you can do it directly. You can put code in the refresh to:
>>>>>

This.Value = TTOD(Table.field)

>>>>>and then in the valid, or wherever works best for you,
>>>>>

>>>>>Local llOk
>>>>>llOk = .T.
>>>>>IF !EMPTY(DTOC(this.Value))   && valid date?
>>>>>   IF this.Value <> TTOD(table.field)   && changed?
>>>>>      replace table.field WITH DTOT(this.Value)
>>>>>   Endif
>>>>>Else
>>>>>   llOk = .F.
>>>>>   MessageBox('Invalid date')
>>>>>ENDIF
>>>>>
>>>>>Return llOk
>>>>>

>>>>>
>>>>>>Does anyone know if it is possible to limit a textbox to only display and allow editing of the date portion of a datatime field?
>>>>>>
>>>>>>Thanks, BOb