System Time

G

Guest

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.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting Concurrent timed events 7
percentage calculated shows in form, but not in report 1
Avg. 1-month, 3-month, 6-month & 12-month Stock Returns 2
Rounding down and displaying as a fraction 2
Programming "Yield" function in Access 5
How many are more than 15 minutes late 2
Month calculation from cost for a business plan - please help 3
summing up values with in date intervals 2

Top