Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Time Fields
Message
 
To
12/03/2006 21:00:16
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01103567
Message ID:
01103644
Views:
12
>Ok tnx But how could I suppress the date inside a form? tnx again

If you surpress the date then the nuser cannot enter the date and you have the same problem.

To surpress the date you use the TTOT() function to get then time out of the datetime value. Y0u would need to put code in the events of the textbox, in the refresh() you could put ...
This.Value = TTOT(SomeTableAlias.DatetimeField)
In the LostFocus() you could put ...
REPLACE SomeTbaleAlias.DatetimeField WITH TRANSFORM(YEAR(DATE())) + "/" + TRANSFORM(MONTH(DATE())) + "/" + TRANSFORM(DAY(DATE())) + " " + This.Value
But using the above code will again present ther same problem I mentioned in the previous message. The date is being forced to today and you lose the TimeIN is on a particular date as is the time out.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform