Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date/Time field on form
Message
 
To
28/08/2002 10:52:33
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00694453
Message ID:
00694510
Views:
11
>I'm working in VFP6. I have a table with a datetime field and a form with a control using that field. The content of the field for a record in the table os 04/09/2002 20:18:03. When I run the form, it displays 12/30/1899 20:18:03.
>
>As I move through the records, all the times are correct but the date remains displayed at 12/30/1899.
>
>What am I doing wrong?
>
>Judy Scofield

'12/30/1899' is a 'default' date in VFP. Do you use ttod or ttoc functions? They may show the 'default' date in some cases. As it is in VFP Help:
*-----------------
TTOD(tExpression)
Returns
Date
Arguments
tExpression
Specifies a date and time expression from which TTOD( ) returns a Date value. tExpression must evaluate to a valid DateTime. If tExpression contains only a time, Visual FoxPro adds the default date of 12/30/1899 to tExpression and returns this default date.
*--------------
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform