>
> 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
> 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