Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date only format
Message
From
07/04/2003 20:30:20
 
 
To
07/04/2003 15:37:43
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00774834
Message ID:
00774964
Views:
17
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform