Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Time Fields
Message
 
To
12/03/2006 17:56:38
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:
01103580
Views:
15
>Sir excuse me ...
> What data type will I use in a Time Field.... Because If I use Date/Time Data type , It also shows the date . How can I filter my time field for just the time. Because I have a field named Time In and Time Out.. Tnx You very much sir.. Hope you could help me with this..

Roamarck,

You do want to use a Datetime field. You can surpress the diplay of the date if you want, but whne calculating the duration from time in and time out it is important to have the date as time out may be the next day at an earlier time. This would cause your calculations to be iincorrect if you didn't have the date as part of the value.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform