AnsweredAssumed Answered

VRF-hp vee 5 & ms access

Question asked by VRFuser on Jan 26, 1999
>
> Attached is a test program and mdb database.  When I pull a desire
> record from the database, the date shows as the previous day.  Why does
> HP Vee subtract one day from date in the record? 

It looks like the time is off by one hour (11:00 PM instead of midnight) after
converting the date from the database into a VEE timestamp.  Therefore the VEE
date is one day behind.  I don't know how or where Date/Time values are
converted to VEE timestamps, so I don't know if the problem is with VEE or DAO.

As a workaround to get the right date value for your example, you can add 3601
to the field value returned for the date.  Note that time 00:00:00 is the last
second of the day.  The date rolls over between 00:00:00 and 00:00:01.

Regards,

Bruce Wenner
HP St. Paul



Outcomes