System Time

J

Jay

Hello,

Could someone plase help me. I have written a stock settlement report which
calculates how many working days until the stock needs to be paid for and
reports T+3, T+2, T+1, today. The problem I have is that the number of days
it calculates to be the answer is out by 1 day if the report is run before
12pm and is accurate after 12pm.

Is there a solution to this?

Many thanks in advance

J
 
M

missinglinq via AccessMonster.com

The code you're using for the calculation would be helpful.
 
J

Jeff Boyce

Jay

Are you using a date/time field and adding? Are you using Now() or Date()
to put a value in that field?
 
Top