Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Datetime Field To Only Date
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00008445
Message ID:
00008454
Views:
35
>I had remote view created from ORACLE, and ORACLE ODBC driver by default create datetime
>datatype for date field. If I bound this view field to TextBox Control with
>controlsource property of form, then form display date & time on the form and user had
>to enter date and time or press enter after entering date to avoid time entry.
>
>I want just date to be displayed in TextBox Control and when user finishes date entry
>cursor should move to next field skiping time.
>
>I had tried by setting input mask/ format property of TextBox as ##/##/##, 99/99/99, it
>does not work. Any help in this regard is most wellcome.
>
>DO WHILE .T.
> Thanks in Advance
>ENDDO

Waheed

Welcome to the Jungle... (S) In my experience (Ahem!), DateTime is really in a sense just a DB validation data type. For general Date AND Time you should get old fashioned. I beat my head on this one myself.

HTH,
Tom
Tom
--------------------------------
Tom O'Hare
407-299-4268 -- tom@redtile.com -- http://www.redtile.com/
Independent Programmer Using Visual FoxPro, Visual Basic & more...
Operations Manager -- Virtual FoxPro User Group (VFUG)
http://www.vfug.org/ -- tom@vfug.org
President -- Central Florida FoxPro User Group (CFFUG)
http://www.redtile.com/foxpro/
Universal Thread Most Valued Professional (MVP)
http://www.transformation.com/foxpro/
Previous
Reply
Map
View

Click here to load this message in the networking platform