Dates - 2 questions

  • Thread starter Thread starter Rohan via AccessMonster.com
  • Start date Start date
R

Rohan via AccessMonster.com

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.
 
Access really stores dates as floating point decimal numbers, Years on
the left of the decimal, and Seconds on the right.
Click to expand...

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]
 
Back
Top