Calculating the Number of Days Between Two Dates

[Paul]

I need to calculate the number of days between a fixed
date (i.e. 09/31/92) and the present date. Can someone
tell me how? Thanks in advance for the help.

 

[Douglas J. Steele]

Use the DateDiff function.

DateDiff("d", #9/31/1992#, Date())

Of course, this has nothing to do with table design...

 

[Douglas J. Steele]

Ten gets you fifty he'll be back asking how to calculate this in a

table...

Do I look that stupid? <g>

(Of course, if you want to give me 50 pounds for my 10 Cdn$ wager... <g>)