I've got 2 date/time fields I want to combine/add and put in another date/time field in another table. Here's an example of the 2 fields:
[arrivetime] [WaitingPeriod]
9/16/2002 11:49:49 PM 1:29:00 AM
Logically if you add them you would get:
9/17/2002 1:18:49 AM
But I'm getting:
9/15/2002 1:18:49 AM
Everything appears to be correct except it subtracted a day instead of adding a day. Here's the query I used:
INSERT INTO archive ( InProgress )
SELECT [WaitingPeriod]+[arrivetime] AS InProgress
FROM archive_old
WHERE (((ArriveTime)<'9/17/2002'));
thanks
[arrivetime] [WaitingPeriod]
9/16/2002 11:49:49 PM 1:29:00 AM
Logically if you add them you would get:
9/17/2002 1:18:49 AM
But I'm getting:
9/15/2002 1:18:49 AM
Everything appears to be correct except it subtracted a day instead of adding a day. Here's the query I used:
INSERT INTO archive ( InProgress )
SELECT [WaitingPeriod]+[arrivetime] AS InProgress
FROM archive_old
WHERE (((ArriveTime)<'9/17/2002'));
thanks