General information
Category:
Forms & Form designer
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only