Question 1.

I have a query where I ask for expr1: Now()-submission_date where
submission date is a date
datatype in the database. I get the number of days and a remainder, eg. 27.
38962963 the remainder
is the same for each result. What gives ?

Question 2.

How do I find the date four months before any given date ?

Rohan.

--
Message posted via http://www.accessmonster.com

Thank you both.

Rohan.

--
Message posted via http://www.accessmonster.com

On Tue, 31 Jan 2006 19:20:09 -0500, "Al Camp" <(E-Mail Removed)> wrote:

> Access really stores dates as floating point decimal numbers, Years on
>the left of the decimal, and Seconds on the right.

Actually it's a count of days (the left of the decimal) and fractions
of a day (to the right) since midnight, December 30, 1899. E.g.

?now
1/31/2006 6:38:26 PM
?cdbl(now())
38748.7768518519
?cdbl(#12/30/1999 12:00:00#)
36524.5


John W. Vinson[MVP]