Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Return centesimal or millesimal seconds with Datetime()
Message
From
04/12/1998 15:10:33
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00164082
Message ID:
00164244
Views:
23
>>Yowsa! Maybe your problem was "crossing midnight" with "t" value (>86400) or was "t" now part of the new day (date+1 t%86400)?
>
>no, it was like your problem looking at the data in VFP it was not obvious that the internal values were not what was displaying. I had to put the record values into a temp table and use my hex file viewer to see that the data was one bit smaller than the "equivalent" datetime constant stored in the same table.

OIC. My problem did not show up once you wrote the date to a field and then used the date from the field. The "extra" value that was in the memory variable of the date was no longer there when it came back from the table's value. It still caused problems if you tried to compare it to a memvar with the "extra" still on it, though.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Reply
Map
View

Click here to load this message in the networking platform